APPS.AP_ETAX_SERVICES_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 6827: FROM hr_all_organization_units

6823: ----------------------------------------------------------------------
6824: BEGIN
6825: SELECT location_id
6826: INTO l_bill_to_location_id
6827: FROM hr_all_organization_units
6828: WHERE organization_id = P_Invoice_Header_Rec.org_id;
6829:
6830: EXCEPTION
6831: WHEN no_data_found THEN

Line 9367: FROM hr_all_organization_units

9363: ------------------------------------------------------------------------
9364: BEGIN
9365: SELECT location_id
9366: INTO l_bill_to_location_id
9367: FROM hr_all_organization_units
9368: WHERE organization_id = P_Invoice_Header_Rec.org_id;
9369:
9370: EXCEPTION
9371: WHEN no_data_found THEN

Line 13202: FROM hr_all_organization_units

13198: ----------------------------------------------------------------------
13199: BEGIN
13200: SELECT location_id
13201: INTO l_bill_to_location_id
13202: FROM hr_all_organization_units
13203: WHERE organization_id = P_Invoice_Header_Rec.org_id;
13204: END;
13205:
13206: ----------------------------------------------------------------------

Line 14141: FROM hr_all_organization_units

14137: ------------------------------------------------------------
14138:
14139: SELECT location_id
14140: INTO AP_ETAX_SERVICES_PKG.g_org_attributes(p_org_id).bill_to_location_id
14141: FROM hr_all_organization_units
14142: WHERE organization_id = p_org_id;
14143:
14144: END IF;
14145: