DBA Data[Home] [Help]

APPS.JAI_CMN_TAX_DEFAULTATION_PKG dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 263: FROM org_organization_definitions

259:
260:
261: CURSOR operating_unit_cur(c_org_id NUMBER) IS
262: SELECT operating_unit
263: FROM org_organization_definitions
264: WHERE organization_id = NVL(c_org_id, 0);
265:
266: -- to get tax_category_id from Item class
267: CURSOR tax_catg_id_cur(v_org_id IN NUMBER, v_inventory_item_id IN NUMBER, v_operating_unit NUMBER) IS

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

265:
266: -- to get tax_category_id from Item class
267: CURSOR tax_catg_id_cur(v_org_id IN NUMBER, v_inventory_item_id IN NUMBER, v_operating_unit NUMBER) IS
268: SELECT b.tax_category_id
269: FROM JAI_INV_ITM_SETUPS a , JAI_CMN_TAX_CTGS_ALL b -- redundant, org_organization_definitions c
270: WHERE a.item_class = b.item_class_cd
271: AND a.inventory_item_id = v_inventory_item_id
272: AND a.organization_id = v_org_id
273: AND b.org_id = v_operating_unit;