DBA Data[Home] [Help]

APPS.JAI_CMN_TAX_DEFAULTATION_PKG dependencies on JAI_CMN_TAX_CTGS_ALL

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;