DBA Data[Home] [Help]

APPS.PAY_NL_NSI_PROCESS dependencies on PAY_NL_GENERAL

Line 173: ,pay_nl_general.get_postal_code(hr_loc.postal_code) postal_code

169: ,hr_loc.style style
170: ,hr_loc.loc_information14 House_Num
171: ,hr_loc.loc_information15 House_Num_Add
172: ,hr_loc.region_1 street_name
173: ,pay_nl_general.get_postal_code(hr_loc.postal_code) postal_code
174: ,hr_general.decode_lookup('HR_NL_CITY', hr_loc.town_or_city) city
175: FROM hr_organization_units hr_org
176: ,hr_locations hr_loc
177: WHERE hr_org.organization_id = p_organization_id

Line 800: ,pay_nl_general.get_postal_code(ee_addr.postal_code) postal_code

796: SELECT ee_addr.style style
797: ,ee_addr.add_information13 House_Num
798: ,ee_addr.add_information14 House_Num_Add
799: ,ee_addr.region_1 street_name
800: ,pay_nl_general.get_postal_code(ee_addr.postal_code) postal_code
801: ,hr_general.decode_lookup('HR_NL_CITY', ee_addr.town_or_city) city
802: ,ee_addr.country country
803: FROM per_addresses ee_addr
804: WHERE ee_addr.person_id = lp_person_id