APPS.JAI_OM_RMA_PKG dependencies on JAI_OM_OE_RMA_TAXES

Line 383: INSERT INTO JAI_OM_OE_RMA_TAXES

379: v_round_func := 0;
380: END IF;
381:
382:
383: INSERT INTO JAI_OM_OE_RMA_TAXES
384: (rma_line_id,
385: delivery_detail_id,
386: tax_line_no,
387: precedence_1,

Line 594: INSERT INTO JAI_OM_OE_RMA_TAXES

590: open c_sales_order_cur;
591: fetch c_sales_order_cur into v_orig_ord_qty,v_service_type_code;
592: close c_sales_order_cur;
593:
594: INSERT INTO JAI_OM_OE_RMA_TAXES
595: (rma_line_id,
596: delivery_detail_id,
597: tax_line_no,
598: precedence_1,

Line 808: DELETE FROM JAI_OM_OE_RMA_TAXES

804: BEGIN
805:
806: DELETE FROM JAI_OM_OE_RMA_LINES
807: WHERE rma_line_id = p_line_id;
808: DELETE FROM JAI_OM_OE_RMA_TAXES
809: WHERE rma_line_id = p_line_id;
810: END delete_data;
811:
812: BEGIN

Line 1021: FROM JAI_OM_OE_RMA_TAXES rtl,

1017: rtl.precedence_7,
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