APPS.PAY_CN_PAYSLIP_ARCHIVE dependencies on HR_GENERAL

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

342: CURSOR csr_leave_balance
343: IS
344: --
345: SELECT pap.accrual_plan_name
346: ,hr_general_utilities.get_lookup_meaning('US_PTO_ACCRUAL',pap.accrual_category)
347: ,pap.accrual_units_of_measure
348: ,ppa.payroll_id
349: ,pap.business_group_id
350: ,pap.accrual_plan_id

Line 1585: ,hr_general.decode_lookup('CN_PROVINCE',hl.town_or_city) province

1581:
1582: CURSOR csr_le_address IS
1583: SELECT hl.address_line_1
1584: ,hl.address_line_2
1585: ,hr_general.decode_lookup('CN_PROVINCE',hl.town_or_city) province
1586: ,ft.territory_short_name country
1587: ,hl.postal_code
1588: ,hl.telephone_number_1
1589: FROM hr_all_organization_units hou

Line 1840: ,hr_general.decode_lookup('CN_PAYOUT_LOCATION',hsck.segment22) -- Payout Location

1836: --
1837: CURSOR csr_soft_key
1838: IS
1839: SELECT hsck.segment20 -- Tax Area
1840: ,hr_general.decode_lookup('CN_PAYOUT_LOCATION',hsck.segment22) -- Payout Location
1841: FROM hr_soft_coding_keyflex hsck
1842: ,per_all_assignments_f paaf
1843: ,pay_assignment_actions paa
1844: ,pay_payroll_actions ppa