240: JAI_AR_TRXS trx
241: WHERE customer_trx_id = v_customer_trx_id
242: AND EXISTS
243: (SELECT 1
244: FROM ra_interface_lines_all il
245: WHERE il.customer_trx_id = v_customer_trx_id
246: AND NVL(il.interface_status , '~') <> 'P'
247: );
248:
1300: */
1301: cursor c_ont_source_code is
1302: select FND_PROFILE.VALUE('ONT_SOURCE_CODE')
1303: from dual;
1304: v_ont_source_code ra_interface_lines_all.interface_line_context%type;
1305: /*
1306: ends here additions by sriram -bug#3607101
1307: */
1308:
4327: */
4328: cursor c_ont_source_code is
4329: select FND_PROFILE.VALUE('ONT_SOURCE_CODE')
4330: from dual;
4331: v_ont_source_code ra_interface_lines_all.interface_line_context%type;
4332: /*
4333: ends here additions by sriram -bug#3680721
4334: */
4335: