APPS.PAY_IE_P35 dependencies on HR_GENERAL

Line 1365: hr_general.decode_lookup (

1361: NVL (TRIM (pact_ad.action_information6), ' '), -- ADDRESS_LINE2
1362: NVL (TRIM ( pact_ad.action_information7), ' '), -- ADDRESS_LINE3 BUG 4066315
1363: NVL (
1364: TRIM (
1365: hr_general.decode_lookup (
1366: 'IE_COUNTY',
1367: TRIM (pact_ad.action_information9)
1368: )
1369: ||' '||

Line 1370: hr_general.decode_lookup (

1366: 'IE_COUNTY',
1367: TRIM (pact_ad.action_information9)
1368: )
1369: ||' '||
1370: hr_general.decode_lookup (
1371: 'IE_POSTAL_CODE',
1372: TRIM (pact_ad.action_information12)
1373: )
1374: ),

Line 1526: NVL (TRIM (hr_general.decode_lookup ('IE_COUNTY',

1522: TO_CHAR (ppf.date_of_birth, 'dd-mm-yyyy'), --DOB
1523: NVL (TRIM (RPAD (pad.address_line1, 30)), ' '), --ADDRESS_LINE1
1524: NVL (TRIM (pad.address_line2), ' '), --ADDRESS_LINE2
1525: NVL (TRIM (pad.address_line3), ' '), --ADDRESS_LINE3
1526: NVL (TRIM (hr_general.decode_lookup ('IE_COUNTY',
1527: TRIM (pad.region_1)
1528: )
1529: ||' '|| (
1530: hr_general.decode_lookup (

Line 1530: hr_general.decode_lookup (

1526: NVL (TRIM (hr_general.decode_lookup ('IE_COUNTY',
1527: TRIM (pad.region_1)
1528: )
1529: ||' '|| (
1530: hr_general.decode_lookup (
1531: 'IE_POSTAL_CODE',
1532: TRIM (pad.postal_code)
1533: )
1534: )

Line 1730: hr_general.decode_lookup (

1726: NVL (TRIM (pad.address_line2), ' '), -- ADDRESS_LINE2
1727: NVL (TRIM (pad.address_line3), ' '), -- ADDRESS_LINE3
1728: NVL (
1729: TRIM (
1730: hr_general.decode_lookup (
1731: 'IE_COUNTY',
1732: TRIM (pad.region_1)
1733: )
1734: ||' '||

Line 1735: hr_general.decode_lookup (

1731: 'IE_COUNTY',
1732: TRIM (pad.region_1)
1733: )
1734: ||' '||
1735: hr_general.decode_lookup (
1736: 'IE_POSTAL_CODE',
1737: TRIM (pad.postal_code)
1738: )
1739: ),