APPS.PAY_NL_CBS_FILE dependencies on HR_ORGANIZATION_UNITS

Line 147: and location_id = (select location_id from hr_organization_units where organization_id = p_org_id);

143: cursor csr_loc_extra_info(p_org_id number) IS
144: select lei_information10,lei_information11
145: from hr_location_extra_info
146: where information_type = 'NL_POSTAL_ADDRESS'
147: and location_id = (select location_id from hr_organization_units where organization_id = p_org_id);
148: begin
149: -- hr_utility.set_location('Entering Get_loc_extra_info',600);
150: open csr_loc_extra_info(p_org_id);
151: fetch csr_loc_extra_info into p_contact,p_telephone;