APPS.PAY_HK_SOE_PKG dependencies on HR_GENERAL

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

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

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

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

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

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