/*******************************************************************************
* *
* FORMULA NAME: GET_PER_HR_VALUE *
* FORMULA TYPE: Payroll Access to HR *
* DESCRIPTION: This formula will return the HR Data for employee *
* *
* Who Date Description *
* ---------- ---------- -------------------------------------- *
* *
********************************************************************************/
DEFAULT FOR PER_ASG_BARGAINING_UNIT_CODE IS 'X'
DEFAULT FOR PER_ASG_ORG_DEPARTMENT_NAME IS 'X'
DEFAULT FOR PER_ASG_ORG_UNION_NAME IS 'X'
DEFAULT FOR PER_ASG_GRADE_NAME IS 'X'
DEFAULT FOR PER_ASG_GRADE_LADDER_NAME IS 'X'
DEFAULT FOR PER_GRADE_STEP_NAME IS 'X'
DEFAULT FOR PER_ASG_POSITION_NAME is 'X'
DEFAULT FOR PER_ASG_REL_ACTUAL_TERMINATION_DATE is '0001/01/01 00:00:00' (Date)
DEFAULT FOR PER_PER_LATEST_REHIRE_DATE is '0001/01/01 00:00:00' (Date)
DEFAULT FOR PER_PER_TERMINATION_REASON IS 'X'
DEFAULT FOR PER_EMP_TERMINATION_ACTION_NAME IS 'X'
DEFAULT FOR PER_ASG_POSITION_ID is 0
Inputs are P_HR_ASSIGNMENT_ID,
P_EFFECTIVE_DATE (date)
l_dummy = PAY_INTERNAL_LOG_WRITE('(GET_PER_HR_VALUE) P_EFFECTIVE_DATE : '||TO_CHAR(P_EFFECTIVE_DATE))
l_dummy = PAY_INTERNAL_LOG_WRITE('(GET_PER_HR_VALUE) P_HR_ASSIGNMENT_ID : '||TO_CHAR(P_HR_ASSIGNMENT_ID))
CHANGE_CONTEXTS (EFFECTIVE_DATE = P_EFFECTIVE_DATE)
(
CHANGE_CONTEXTS (HR_ASSIGNMENT_ID = P_HR_ASSIGNMENT_ID)
(
l_bargaining_unit = PER_ASG_BARGAINING_UNIT_CODE
l_department_name = PER_ASG_ORG_DEPARTMENT_NAME
l_union_name = PER_ASG_ORG_UNION_NAME
l_Grade_name = PER_ASG_GRADE_NAME
l_Grade_step_name=PER_GRADE_STEP_NAME
l_position_name=PER_ASG_POSITION_NAME
l_termination_date=PER_ASG_REL_ACTUAL_TERMINATION_DATE
l_hire_date=PER_PER_LATEST_REHIRE_DATE
l_action_reason=PER_PER_TERMINATION_REASON
l_action_type=PER_EMP_TERMINATION_ACTION_NAME
l_position_id=PER_ASG_POSITION_ID
)
)
l_dummy = PAY_INTERNAL_LOG_WRITE('(GET_PER_HR_VALUE) l_bargaining_unit : '||l_bargaining_unit)
l_dummy = PAY_INTERNAL_LOG_WRITE('(GET_PER_HR_VALUE) l_department_name : '||l_department_name)
l_dummy = PAY_INTERNAL_LOG_WRITE('(GET_PER_HR_VALUE) l_union_name : '||l_union_name)
l_dummy = PAY_INTERNAL_LOG_WRITE('(GET_PER_HR_VALUE) l_Grade_name : '||l_Grade_name)
l_dummy = PAY_INTERNAL_LOG_WRITE('(GET_PER_HR_VALUE) l_Grade_step_name : '||l_Grade_step_name)
l_dummy = PAY_INTERNAL_LOG_WRITE('(GET_PER_HR_VALUE) l_termination_date : '||to_char(l_termination_date))
l_dummy = PAY_INTERNAL_LOG_WRITE('(GET_PER_HR_VALUE) l_hire_date : '||to_char(l_hire_date))
l_dummy = PAY_INTERNAL_LOG_WRITE('(GET_PER_HR_VALUE) l_action_reason : '||l_action_reason)
l_dummy = PAY_INTERNAL_LOG_WRITE('(GET_PER_HR_VALUE) l_action_type : '||l_action_type)
return l_bargaining_unit,l_department_name,l_union_name, l_Grade_name,l_Grade_step_name,l_position_name, l_hire_date, l_action_reason, l_action_type
Thinkapace Admin
