APPS.PAY_HK_SOE_PKG dependencies on HR_GENERAL

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

768:
769: CURSOR csr_get_annual_leave_details(p_payroll_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
770: IS
771: SELECT pap.accrual_plan_name
772: ,hr_general_utilities.get_lookup_meaning('US_PTO_ACCRUAL',pap.accrual_category)
773: ,hr_general.decode_lookup('HOURS_OR_DAYS',pap.accrual_units_of_measure)
774: ,ppa.payroll_id
775: ,pap.business_group_id
776: ,pap.accrual_plan_id

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

769: CURSOR csr_get_annual_leave_details(p_payroll_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
770: IS
771: SELECT pap.accrual_plan_name
772: ,hr_general_utilities.get_lookup_meaning('US_PTO_ACCRUAL',pap.accrual_category)
773: ,hr_general.decode_lookup('HOURS_OR_DAYS',pap.accrual_units_of_measure)
774: ,ppa.payroll_id
775: ,pap.business_group_id
776: ,pap.accrual_plan_id
777: ,paa.assignment_id

Line 940: ,hr_general.decode_lookup(''HOURS_OR_DAYS'',pat.HOURS_OR_DAYS) COL04

936: g_sql :=
937: ' SELECT pet.reporting_name COL01
938: ,TO_CHAR(decode(pet.processing_type,''R'',greatest(pab.date_start,PTP.START_DATE),pab.date_start),''DD-Mon-YYYY'') COL02
939: ,TO_CHAR(decode(pet.processing_type,''R'',least(pab.date_end,PTP.END_DATE),pab.date_end),''DD-Mon-YYYY'') COL03
940: ,hr_general.decode_lookup(''HOURS_OR_DAYS'',pat.HOURS_OR_DAYS) COL04
941: ,TO_CHAR(decode(pet.processing_type,''R'',to_number(prrv.result_value),nvl(pab.absence_days,pab.absence_hours))) COL16
942: FROM pay_assignment_actions paa
943: ,pay_payroll_actions ppa
944: ,pay_run_results prr