APPS.JAI_AR_IMPORT_POPU_PKG dependencies on JAI_OM_OE_RMA_TAXES

Line 4882: FROM JAI_OM_OE_RMA_TAXES A, JAI_CMN_TAXES_ALL b

4878: 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,
4879: A.func_tax_amount,
4880: A.precedence_1, A.precedence_2, A.precedence_3, A.precedence_4, A.precedence_5 ,
4881: A.precedence_6, A.precedence_7, A.precedence_8, A.precedence_9, A.precedence_10
4882: FROM JAI_OM_OE_RMA_TAXES A, JAI_CMN_TAXES_ALL b
4883: WHERE A.rma_line_id = v_interface_line_attribute7
4884: AND A.tax_id = b.tax_id
4885: and b.tax_type <> lc_modvat_tax
4886: ORDER BY tax_line_no;

Line 4904: FROM JAI_OM_OE_RMA_TAXES

4900:
4901:
4902: CURSOR SO_RMA_TAX_RECORD_CHECK IS
4903: SELECT 1
4904: FROM JAI_OM_OE_RMA_TAXES
4905: WHERE rma_line_id = v_interface_line_attribute7;
4906:
4907:
4908: v_trans_type VARCHAR2(30);

Line 5053: FROM JAI_OM_OE_RMA_TAXES A, JAI_CMN_TAXES_ALL b

5049: 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,
5050: A.func_tax_amount,
5051: A.precedence_1, A.precedence_2, A.precedence_3, A.precedence_4, A.precedence_5 ,
5052: A.precedence_6, A.precedence_7, A.precedence_8, A.precedence_9, A.precedence_10
5053: FROM JAI_OM_OE_RMA_TAXES A, JAI_CMN_TAXES_ALL b
5054: WHERE A.rma_line_id = TO_NUMBER(v_interface_line_attribute7)
5055: AND A.tax_id = b.tax_id
5056: and b.tax_type <> lc_modvat_tax
5057: ORDER BY tax_line_no;