DBA Data[Home] [Help]

APPS.JAI_OM_RMA_PKG dependencies on JAI_CMN_TAXES_ALL

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

97: select quantity ,service_type_code /* added by ssawant for bug 5879769 */
98: from JAI_OM_OE_SO_LINES
99: where line_id = p_new_reference_line_id;
100:
101: Cursor C_SO_TAX_AMOUNT (p_tax_id JAI_CMN_TAXES_ALL.tax_id%type) is
102: select tax_amount
103: from JAI_OM_OE_SO_TAXES
104: where line_id = p_new_reference_line_id
105: and tax_id = p_tax_id;

Line 312: JAI_CMN_TAXES_ALL jtc

308: precedence_8,
309: precedence_9,
310: precedence_10
311: FROM JAI_OM_WSH_LINE_TAXES sptl,
312: JAI_CMN_TAXES_ALL jtc
313: WHERE delivery_detail_id = v_delivery_detail_id
314: AND jtc.tax_id = sptl.tax_id)
315: LOOP
316:

Line 767: JAI_CMN_TAXES_ALL jtc

763: rtl.precedence_8,
764: rtl.precedence_9,
765: rtl.precedence_10
766: FROM JAI_OM_OE_RMA_TAXES rtl,
767: JAI_CMN_TAXES_ALL jtc
768: WHERE rtl.rma_line_id = p_rma_line_id
769: AND jtc.tax_id = rtl.tax_id)
770: LOOP
771: ln_rma_amt := 0 ;