APPS.JAI_AR_RCTLA_TRIGGER_PKG dependencies on JAI_OM_OE_RMA_LINES

Line 166: from JAI_OM_OE_RMA_LINES

162: where line_id = to_number(pr_old.interface_line_attribute6);
163:
164: cursor c_check_rma_line is
165: select 1
166: from JAI_OM_OE_RMA_LINES
167: where rma_line_id = to_number(pr_old.interface_line_attribute6);
168:
169: v_so_line_check Number :=0;
170: v_rma_line_check Number :=0;

Line 4599: FROM JAI_OM_OE_RMA_LINES

4595: ||Added by Ramananda for the bug 4567935 (115 bug4404898)
4596: */
4597: CURSOR SO_RMA_LINES_INFO IS
4598: SELECT tax_category_id, assessable_value, service_type_code -- service_type_code added by csahoo for bug#5879769
4599: FROM JAI_OM_OE_RMA_LINES
4600: WHERE rma_line_id = v_interface_line_attribute7;
4601: /*
4602: ||End of bug 4567935
4603: */

Line 4627: FROM JAI_OM_OE_RMA_LINES

4623:
4624: /* Cursor To Check Whether Interfaced Record Exist in JAI_OM_WSH_LINES_ALL */
4625: CURSOR SO_RMA_RECORD_CHECK IS
4626: SELECT 1
4627: FROM JAI_OM_OE_RMA_LINES
4628: WHERE rma_line_id = v_interface_line_attribute7;
4629:
4630:
4631: CURSOR SO_RMA_TAX_RECORD_CHECK IS

Line 4648: FROM JAI_OM_OE_RMA_LINES

4644:
4645:
4646: CURSOR SO_RMA_QUANTITY_CHECK IS
4647: SELECT NVL(quantity,0)
4648: FROM JAI_OM_OE_RMA_LINES
4649: WHERE rma_line_id = v_interface_line_attribute7;
4650:
4651: /* bug 5243532. Added by Lakshmi Gopalsami
4652: Removed the reference to cursor set_of_books_cur

Line 4750: FROM JAI_OM_OE_RMA_LINES

4746:
4747: CURSOR SO_RMA_LINES_INFO IS
4748: --added unit_code,line_amount
4749: SELECT tax_category_id, assessable_value, service_type_code, quantity, inventory_item_id ,uom, selling_price
4750: FROM JAI_OM_OE_RMA_LINES
4751: WHERE rma_line_id = TO_NUMBER(v_interface_line_attribute7);
4752:
4753: CURSOR SO_RMA_TAX_LINES_INFO IS
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,