APPS.JAI_CMN_TAX_DEFAULTATION_PKG dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 295: FROM org_organization_definitions

291:
292:
293: CURSOR operating_unit_cur(c_org_id NUMBER) IS
294: SELECT operating_unit
295: FROM org_organization_definitions
296: WHERE organization_id = NVL(c_org_id, 0);
297:
298: -- to get tax_category_id from Item class
299: CURSOR tax_catg_id_cur(v_org_id IN NUMBER, v_inventory_item_id IN NUMBER, v_operating_unit NUMBER) IS

Line 301: FROM JAI_INV_ITM_SETUPS a , JAI_CMN_TAX_CTGS_ALL b -- redundant, org_organization_definitions c

297:
298: -- to get tax_category_id from Item class
299: CURSOR tax_catg_id_cur(v_org_id IN NUMBER, v_inventory_item_id IN NUMBER, v_operating_unit NUMBER) IS
300: SELECT b.tax_category_id
301: FROM JAI_INV_ITM_SETUPS a , JAI_CMN_TAX_CTGS_ALL b -- redundant, org_organization_definitions c
302: WHERE a.item_class = b.item_class_cd
303: AND a.inventory_item_id = v_inventory_item_id
304: AND a.organization_id = v_org_id
305: AND b.org_id = v_operating_unit;