APPS.PAY_IE_P35 dependencies on HR_GENERAL

Line 1672: hr_general.decode_lookup (

1668: NVL (TRIM (pact_ad.action_information6), ' '), -- ADDRESS_LINE2
1669: NVL (TRIM ( pact_ad.action_information7), ' '), -- ADDRESS_LINE3 BUG 4066315
1670: NVL (
1671: TRIM (
1672: hr_general.decode_lookup (
1673: 'IE_COUNTY',
1674: TRIM (pact_ad.action_information9)
1675: )
1676: ||' '||

Line 1677: hr_general.decode_lookup (

1673: 'IE_COUNTY',
1674: TRIM (pact_ad.action_information9)
1675: )
1676: ||' '||
1677: hr_general.decode_lookup (
1678: 'IE_POSTAL_CODE',
1679: TRIM (pact_ad.action_information12)
1680: )
1681: ),

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

1863: TO_CHAR (ppf.date_of_birth, 'dd-mm-yyyy'), --DOB
1864: NVL (TRIM (RPAD (pad.address_line1, 30)), ' '), --ADDRESS_LINE1
1865: NVL (TRIM (pad.address_line2), ' '), --ADDRESS_LINE2
1866: NVL (TRIM (pad.address_line3), ' '), --ADDRESS_LINE3
1867: NVL (TRIM (hr_general.decode_lookup ('IE_COUNTY',
1868: TRIM (pad.region_1)
1869: )
1870: ||' '|| (
1871: hr_general.decode_lookup (

Line 1871: hr_general.decode_lookup (

1867: NVL (TRIM (hr_general.decode_lookup ('IE_COUNTY',
1868: TRIM (pad.region_1)
1869: )
1870: ||' '|| (
1871: hr_general.decode_lookup (
1872: 'IE_POSTAL_CODE',
1873: TRIM (pad.postal_code)
1874: )
1875: )

Line 2105: hr_general.decode_lookup (

2101: NVL (TRIM (pad.address_line2), ' '), -- ADDRESS_LINE2
2102: NVL (TRIM (pad.address_line3), ' '), -- ADDRESS_LINE3
2103: NVL (
2104: TRIM (
2105: hr_general.decode_lookup (
2106: 'IE_COUNTY',
2107: TRIM (pad.region_1)
2108: )
2109: ||' '||

Line 2110: hr_general.decode_lookup (

2106: 'IE_COUNTY',
2107: TRIM (pad.region_1)
2108: )
2109: ||' '||
2110: hr_general.decode_lookup (
2111: 'IE_POSTAL_CODE',
2112: TRIM (pad.postal_code)
2113: )
2114: ),