[Home] [Help]
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);