DBA Data[Home] [Help]

APPS.PAY_GB_MOVDED_EDI dependencies on HR_GENERAL

Line 989: upper(hr_general.decode_lookup('GB_COUNTY', substr(addr.region_1,1,35))) county,

985: cursor csr_address is
986: select upper(substr(addr.address_line1,1,35)) addr1,
987: upper(substr(addr.address_line2,1,35)) addr2,
988: upper(substr(addr.address_line3,1,35)) addr3,
989: upper(hr_general.decode_lookup('GB_COUNTY', substr(addr.region_1,1,35))) county,
990: addr.postal_code post_code,
991: upper(addr.town_or_city) town_or_city,
992: upper(addr.country) country
993: from per_addresses addr