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