DBA Data[Home] [Help]

APPS.PAY_NL_NSI_PROCESS dependencies on HR_LOCATIONS

Line 176: ,hr_locations hr_loc

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
178: AND hr_org.location_id = hr_loc.location_id (+);
179: v_csr_get_address csr_get_address%ROWTYPE;
180: v_csr_get_address1 csr_get_address%ROWTYPE;