APPS.JAI_TAX_PROCESSING_PKG dependencies on JAI_OM_OE_RMA_LINES

Line 75: rec_jrl JAI_OM_OE_RMA_LINES%ROWTYPE;

71: l_api_name CONSTANT VARCHAR2(30) := 'CALCULATE_TAX()';
72:
73: -- added by zhiwei.xin for ZX integration of OM part on 2-AUG-2012 begin.
74: rec_jsl JAI_OM_OE_SO_LINES%ROWTYPE;
75: rec_jrl JAI_OM_OE_RMA_LINES%ROWTYPE;
76: rec_old_ool OE_ORDER_LINES_ALL%ROWTYPE;
77: -- added by zhiwei.xin for ZX integration of OM part on 2-AUG-2012 end.
78:
79:

Line 124: from JAI_OM_OE_RMA_LINES joorl

120: select *
121: from OE_ORDER_LINES_ALL oola
122: where oola.HEADER_ID = cp_header_id
123: and not exists (select 1
124: from JAI_OM_OE_RMA_LINES joorl
125: where joorl.RMA_HEADER_ID = cp_header_id
126: and oola.LINE_ID = joorl.RMA_LINE_ID)
127: and not exists (select 1
128: from JAI_OM_OE_SO_LINES joosl

Line 143: from JAI_OM_OE_RMA_LINES joorl

139: from JAI_OM_OE_SO_LINES joosl
140: where joosl.HEADER_ID = cp_header_id
141: and oola.LINE_ID = joosl.LINE_ID)
142: or exists (select 1
143: from JAI_OM_OE_RMA_LINES joorl
144: where joorl.RMA_HEADER_ID = cp_header_id
145: and oola.LINE_ID = joorl.RMA_LINE_ID));
146:
147: cursor c_jai_so_lines (cp_header_id JAI_OM_OE_SO_LINES.HEADER_ID%TYPE,

Line 159: from JAI_OM_OE_RMA_LINES

155: cursor c_jai_rma_lines (cp_header_id JAI_OM_OE_SO_LINES.HEADER_ID%TYPE,
156: cp_line_id JAI_OM_OE_SO_LINES.LINE_ID%TYPE)
157: is
158: select *
159: from JAI_OM_OE_RMA_LINES
160: where RMA_HEADER_ID = cp_header_id
161: and RMA_LINE_ID = cp_line_id;
162: --Added by Zhiwei.xin for ZX integration of OM part end.
163: