DBA Data[Home] [Help]

APPS.PAY_GB_MOVDED_EDI dependencies on HR_GENERAL

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

795: cursor csr_address is
796: select upper(substr(addr.address_line1,1,35)) addr1,
797: upper(substr(addr.address_line2,1,35)) addr2,
798: upper(substr(addr.address_line3,1,35)) addr3,
799: upper(hr_general.decode_lookup('GB_COUNTY', substr(addr.region_1,1,35))) county,
800: addr.postal_code post_code,
801: upper(addr.town_or_city) town_or_city,
802: upper(addr.country) country
803: from per_addresses addr