DBA Data[Home] [Help]

APPS.PAY_NL_CBS_FILE dependencies on HR_LOCATION_EXTRA_INFO

Line 145: from hr_location_extra_info

141: ,p_telephone out nocopy varchar2
142: ) return number IS
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);