APPS.JAI_OM_RMA_PKG dependencies on JAI_CMN_TAXES_ALL

Line 119: Cursor C_SO_TAX_AMOUNT (p_tax_id JAI_CMN_TAXES_ALL.tax_id%type) is

115: select quantity ,service_type_code /* added by ssawant for bug 5879769 */
116: from JAI_OM_OE_SO_LINES
117: where line_id = p_new_reference_line_id;
118:
119: Cursor C_SO_TAX_AMOUNT (p_tax_id JAI_CMN_TAXES_ALL.tax_id%type) is
120: select tax_amount
121: from JAI_OM_OE_SO_TAXES
122: where line_id = p_new_reference_line_id
123: and tax_id = p_tax_id;

Line 330: JAI_CMN_TAXES_ALL jtc

326: precedence_8,
327: precedence_9,
328: precedence_10
329: FROM JAI_OM_WSH_LINE_TAXES sptl,
330: JAI_CMN_TAXES_ALL jtc
331: WHERE delivery_detail_id = v_delivery_detail_id
332: AND jtc.tax_id = sptl.tax_id)
333: LOOP
334:

Line 567: JAI_CMN_TAXES_ALL jtc

563: precedence_8,
564: precedence_9,
565: precedence_10
566: FROM JAI_OM_WSH_LINE_TAXES sptl,
567: JAI_CMN_TAXES_ALL jtc
568: WHERE order_line_id = p_new_reference_line_id
569: AND jtc.tax_id = sptl.tax_id)
570: LOOP
571: -- added by Allen Yang for bug 9691880 10-May-2010, begin

Line 1022: JAI_CMN_TAXES_ALL jtc

1018: rtl.precedence_8,
1019: rtl.precedence_9,
1020: rtl.precedence_10
1021: FROM JAI_OM_OE_RMA_TAXES rtl,
1022: JAI_CMN_TAXES_ALL jtc
1023: WHERE rtl.rma_line_id = p_rma_line_id
1024: AND jtc.tax_id = rtl.tax_id)
1025: LOOP
1026: ln_rma_amt := 0 ;