APPS.ASO_TAX_INT dependencies on HR_ORGANIZATION_UNITS

Line 2277: from HR_ORGANIZATION_UNITS

2273: and quote_line_id is null;
2274:
2275: Cursor c_location_id is
2276: SELECT LOCATION_ID
2277: from HR_ORGANIZATION_UNITS
2278: WHERE ORGANIZATION_ID = l_Shipment_Rec.ship_from_org_id;
2279: -- WHERE ORGANIZATION_ID = l_qte_line_rec.organization_id; commented As per Bug 12830088
2280:
2281: Cursor c_int_org_location is

Line 2283: FROM HR_ORGANIZATION_UNITS

2279: -- WHERE ORGANIZATION_ID = l_qte_line_rec.organization_id; commented As per Bug 12830088
2280:
2281: Cursor c_int_org_location is
2282: SELECT LOCATION_ID
2283: FROM HR_ORGANIZATION_UNITS
2284: WHERE ORGANIZATION_ID=l_qte_header_rec.ORG_ID;
2285:
2286: Cursor c_product_type is
2287: Select CLASSIFICATION_CODE

Line 2335: FROM hr_organization_units hr

2331: AND sysdate BETWEEN nvl(per.effective_start_date,sysdate) AND nvl(per.effective_end_date,sysdate);
2332:
2333: Cursor c_get_location_id ( l_party_id NUMBER) is
2334: SELECT hr.location_id
2335: FROM hr_organization_units hr
2336: WHERE hr.organization_id = l_party_id;
2337:
2338:
2339: -- new variables