APPS.INL_INTEGRATION_GRP dependencies on HR_LOCATIONS

Line 859: FROM hr_locations hl

855: IF l_lci_table(l_ind_lci).location_id IS NOT NULL THEN
856: SELECT hl.location_code, hl.country
857: INTO l_ship_to_location_code,
858: l_taxation_country
859: FROM hr_locations hl
860: WHERE hl.location_id = l_lci_table(l_ind_lci).location_id
861: AND hl.receiving_site_flag = 'Y';
862: END IF;
863:

Line 869: hr_locations hl

865: SELECT hl.location_code, hl.country
866: INTO l_ship_to_location_code,
867: l_taxation_country
868: FROM hr_organization_units hou,
869: hr_locations hl
870: WHERE hl.location_id = hou.location_id
871: AND hl.receiving_site_flag = 'Y'
872: AND hou.organization_id = l_ship_to_org_id;
873: */

Line 3163: FROM hr_locations hl

3159: SELECT hl.location_code,
3160: hl.country
3161: INTO l_ship_to_location_code,
3162: l_taxation_country
3163: FROM hr_locations hl
3164: WHERE hl.location_id = l_ship_to_location_id
3165: AND hl.receiving_site_flag = 'Y';
3166:
3167: l_location_id := l_ship_to_location_id;