DBA Data[Home] [Help]

APPS.JAI_OM_TAX_PKG dependencies on JAI_OM_OE_RMA_LINES

Line 298: from JAI_OM_OE_RMA_LINES

294: -- following cursor added by sriram - bug # 2740443
295:
296: CURSOR c_rma_info (v_header_id Number , v_line_id Number) is
297: Select 1
298: from JAI_OM_OE_RMA_LINES
299: where rma_header_id = v_header_id
300: and rma_line_id = v_line_id;
301:
302: --Comment out by Kevin Cheng for inclusive tax Dec 10, 2007

Line 418: select wdd.source_line_id from wsh_delivery_details wdd, jai_om_oe_rma_lines joorl

414: lv_vat_exemption_flag char(1) := 'N';
415:
416: cursor c_get_base_line_id(cp_line_id oe_order_lines_all.line_id%type)
417: is
418: select wdd.source_line_id from wsh_delivery_details wdd, jai_om_oe_rma_lines joorl
419: where wdd.delivery_detail_id = joorl.delivery_detail_id
420: and joorl.rma_line_id = cp_line_id;
421: lv_reference_Line_id oe_order_lines_all.Reference_Line_id%type;
422: