APPS.JAI_JAR_TRXS_TRIGGER_PKG dependencies on JAI_INV_ITM_SETUPS

Line 148: JAI_INV_ITM_SETUPS C

144: b.tax_type t_type,
145: b.stform_type,
146: a.tax_line_no
147: from JAI_AR_TRX_TAX_LINES A , JAI_CMN_TAXES_ALL B,
148: JAI_INV_ITM_SETUPS C
149: where link_to_cust_trx_line_id = p_line_id
150: and a.tax_id = b.tax_id
151: and c.inventory_item_id = p_inventory_item_id
152: and c.organization_id = p_org_id

Line 157: from JAI_INV_ITM_SETUPS

153: AND c.item_class in ('RMIN','RMEX','CGEX','CGIN','CCEX','CCIN','FGIN','FGEX')
154: order by 1;
155: cursor item_class_cur(P_ORG_ID IN NUMBER,P_INVENTORY_ITEM_ID IN NUMBER) IS
156: select item_class, excise_flag,item_trading_flag
157: from JAI_INV_ITM_SETUPS
158: where inventory_item_id = p_inventory_item_id AND
159: ORGANIZATION_ID = P_ORG_ID;
160: cursor organization_cur IS
161: select organization_id,location_id