APPS.JAI_AR_RCTLA_TRIGGER_PKG dependencies on JAI_OM_OE_RMA_TAXES

Line 4611: FROM JAI_OM_OE_RMA_TAXES A, JAI_CMN_TAXES_ALL b

4607: SELECT A.tax_line_no, A.uom, A.tax_id, A.tax_rate, A.qty_rate, A.base_tax_amount, A.tax_amount, b.tax_type,
4608: A.func_tax_amount,
4609: A.precedence_1, A.precedence_2, A.precedence_3, A.precedence_4, A.precedence_5 ,
4610: A.precedence_6, A.precedence_7, A.precedence_8, A.precedence_9, A.precedence_10
4611: FROM JAI_OM_OE_RMA_TAXES A, JAI_CMN_TAXES_ALL b
4612: WHERE A.rma_line_id = v_interface_line_attribute7
4613: AND A.tax_id = b.tax_id
4614: and b.tax_type <> lc_modvat_tax/*Bug 4881426 bduvarag*/
4615: ORDER BY tax_line_no;

Line 4633: FROM JAI_OM_OE_RMA_TAXES

4629:
4630:
4631: CURSOR SO_RMA_TAX_RECORD_CHECK IS
4632: SELECT 1
4633: FROM JAI_OM_OE_RMA_TAXES
4634: WHERE rma_line_id = v_interface_line_attribute7;
4635:
4636:
4637: v_trans_type VARCHAR2(30);

Line 4758: FROM JAI_OM_OE_RMA_TAXES A, JAI_CMN_TAXES_ALL b

4754: SELECT A.tax_line_no, A.uom, A.tax_id, A.tax_rate, A.qty_rate, A.base_tax_amount, A.tax_amount, b.tax_type,
4755: A.func_tax_amount,
4756: A.precedence_1, A.precedence_2, A.precedence_3, A.precedence_4, A.precedence_5 ,
4757: A.precedence_6, A.precedence_7, A.precedence_8, A.precedence_9, A.precedence_10
4758: FROM JAI_OM_OE_RMA_TAXES A, JAI_CMN_TAXES_ALL b
4759: WHERE A.rma_line_id = TO_NUMBER(v_interface_line_attribute7)
4760: AND A.tax_id = b.tax_id
4761: and b.tax_type <> lc_modvat_tax
4762: ORDER BY tax_line_no;