DBA Data[Home] [Help]

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_qte_line_rec.organization_id;
2279:
2280: Cursor c_int_org_location is
2281: SELECT LOCATION_ID

Line 2282: FROM HR_ORGANIZATION_UNITS

2278: WHERE ORGANIZATION_ID = l_qte_line_rec.organization_id;
2279:
2280: Cursor c_int_org_location is
2281: SELECT LOCATION_ID
2282: FROM HR_ORGANIZATION_UNITS
2283: WHERE ORGANIZATION_ID=l_qte_header_rec.ORG_ID;
2284:
2285: Cursor c_product_type is
2286: Select CLASSIFICATION_CODE

Line 2334: FROM hr_organization_units hr

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