APPS.PAY_CN_PAYSLIP_ARCHIVE dependencies on HR_GENERAL

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

267: CURSOR csr_leave_balance
268: IS
269: --
270: SELECT pap.accrual_plan_name
271: ,hr_general_utilities.get_lookup_meaning('US_PTO_ACCRUAL',pap.accrual_category)
272: ,pap.accrual_units_of_measure
273: ,ppa.payroll_id
274: ,pap.business_group_id
275: ,pap.accrual_plan_id

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

1453:
1454: CURSOR csr_le_address IS
1455: SELECT hl.address_line_1
1456: ,hl.address_line_2
1457: ,hr_general.decode_lookup('CN_PROVINCE',hl.town_or_city) province
1458: ,ft.territory_short_name country
1459: ,hl.postal_code
1460: ,hl.telephone_number_1
1461: FROM hr_all_organization_units hou

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

1708: --
1709: CURSOR csr_soft_key
1710: IS
1711: SELECT hsck.segment20 -- Tax Area
1712: ,hr_general.decode_lookup('CN_PAYOUT_LOCATION',hsck.segment22) -- Payout Location
1713: FROM hr_soft_coding_keyflex hsck
1714: ,per_all_assignments_f paaf
1715: ,pay_assignment_actions paa
1716: ,pay_payroll_actions ppa