DBA Data[Home] [Help]

APPS.PAY_IN_SOE_PKG dependencies on HR_GENERAL

Line 157: ,hr_general.decode_lookup(''IN_RESIDENTIAL_STATUS'',paf.per_information7) COL07

153: ,paf.per_information4 COL03
154: ,paf.per_information8 COL04
155: ,paf.per_information9 COL06
156: ,paf.per_information10 COL05
157: ,hr_general.decode_lookup(''IN_RESIDENTIAL_STATUS'',paf.per_information7) COL07
158: FROM per_all_people_f paf
159: ,per_all_assignments_f asg
160: WHERE
161: asg.assignment_id = '':assignment_id''

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

853:
854: CURSOR csr_get_annual_leave_details(p_payroll_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
855: IS
856: SELECT pap.accrual_plan_name
857: ,hr_general_utilities.get_lookup_meaning('US_PTO_ACCRUAL',pap.accrual_category)
858: ,hr_general.decode_lookup('HOURS_OR_DAYS',pap.accrual_units_of_measure)
859: ,ppa.payroll_id
860: ,pap.business_group_id
861: ,pap.accrual_plan_id

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

854: CURSOR csr_get_annual_leave_details(p_payroll_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
855: IS
856: SELECT pap.accrual_plan_name
857: ,hr_general_utilities.get_lookup_meaning('US_PTO_ACCRUAL',pap.accrual_category)
858: ,hr_general.decode_lookup('HOURS_OR_DAYS',pap.accrual_units_of_measure)
859: ,ppa.payroll_id
860: ,pap.business_group_id
861: ,pap.accrual_plan_id
862: ,paa.assignment_id