APPS.CLN_SYNCCTLG_PKG dependencies on HR_LOCATIONS_ALL

Line 155: from hr_all_organization_units haou, hr_locations_all hla

151: end if;
152:
153: select haou.name, hla.ece_tp_location_code
154: into l_publisher_name, l_publisher_partnridx
155: from hr_all_organization_units haou, hr_locations_all hla
156: where haou.location_id = hla.location_id
157: and haou.organization_id = l_operating_unit_id;
158:
159: if (l_debug_level <= 1) then