DBA Data[Home] [Help]

APPS.PAY_CN_SOE dependencies on HR_GENERAL

Line 478: ,hr_general_utilities.get_lookup_meaning('US_PTO_ACCRUAL',pap.accrual_category)

474:
475: CURSOR csr_get_annual_leave_details(p_payroll_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
476: IS
477: SELECT pap.accrual_plan_name
478: ,hr_general_utilities.get_lookup_meaning('US_PTO_ACCRUAL',pap.accrual_category)
479: ,hr_general.decode_lookup('HOURS_OR_DAYS',pap.accrual_units_of_measure)
480: ,ppa.payroll_id
481: ,pap.business_group_id
482: ,pap.accrual_plan_id

Line 479: ,hr_general.decode_lookup('HOURS_OR_DAYS',pap.accrual_units_of_measure)

475: CURSOR csr_get_annual_leave_details(p_payroll_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
476: IS
477: SELECT pap.accrual_plan_name
478: ,hr_general_utilities.get_lookup_meaning('US_PTO_ACCRUAL',pap.accrual_category)
479: ,hr_general.decode_lookup('HOURS_OR_DAYS',pap.accrual_units_of_measure)
480: ,ppa.payroll_id
481: ,pap.business_group_id
482: ,pap.accrual_plan_id
483: ,paa.assignment_id