APPS.AP_ETAX_SERVICES_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 8263: FROM hr_all_organization_units

8259: ----------------------------------------------------------------------
8260: BEGIN
8261: SELECT location_id
8262: INTO l_bill_to_location_id
8263: FROM hr_all_organization_units
8264: WHERE organization_id = P_Invoice_Header_Rec.org_id;
8265:
8266: EXCEPTION
8267: WHEN no_data_found THEN

Line 11960: FROM hr_all_organization_units

11956: ------------------------------------------------------------------------
11957: BEGIN
11958: SELECT location_id
11959: INTO l_bill_to_location_id
11960: FROM hr_all_organization_units
11961: WHERE organization_id = P_Invoice_Header_Rec.org_id;
11962:
11963: EXCEPTION
11964: WHEN no_data_found THEN

Line 16831: FROM hr_all_organization_units

16827: ----------------------------------------------------------------------
16828: BEGIN
16829: SELECT location_id
16830: INTO l_bill_to_location_id
16831: FROM hr_all_organization_units
16832: WHERE organization_id = P_Invoice_Header_Rec.org_id;
16833: END;
16834: ----------------------------------------------------------------------
16835: l_debug_info := 'Location_id for org_id '|| l_bill_to_location_id||'& '||P_Invoice_Header_Rec.org_id;

Line 17945: FROM hr_all_organization_units

17941: ------------------------------------------------------------
17942:
17943: SELECT location_id
17944: INTO AP_ETAX_SERVICES_PKG.g_org_attributes(p_org_id).bill_to_location_id
17945: FROM hr_all_organization_units
17946: WHERE organization_id = p_org_id;
17947:
17948: END IF;
17949: