APPS.PAY_US_SQWL_UDF dependencies on HR_LOCATION_EXTRA_INFO

Line 921: ,hr_location_extra_info lei

917: ,per_gen_hierarchy_nodes pghn2 -- establishment organizations
918: ,hr_organization_information hoi
919: ,hr_organization_units hou
920: ,hr_locations loc
921: ,hr_location_extra_info lei
922: where pgh.hierarchy_id = Pay_Magtape_Generic.Get_Parameter_Value(
923: 'TRANSFER_HIERARCHY_ID') --parameter p_hierarchy_id
924: and pghv.HIERARCHY_VERSION_id =Pay_Magtape_Generic.Get_Parameter_Value(
925: 'TRANSFER_HIERARCHY_VERSION') --parameter p_hierarchy_verision_number

Line 943: l_reporting_unit_no hr_location_extra_info.lei_information1%TYPE :='0001';

939: and loc.location_id = lei.location_id
940: and lei.information_type = 'Multi Work Site Information'
941: and loc.location_id = cp_location_id;
942:
943: l_reporting_unit_no hr_location_extra_info.lei_information1%TYPE :='0001';
944: l_location_id NUMBER;
945:
946: BEGIN
947: