DBA Data[Home] [Help]

APPS.JAI_AR_RCTLA_TRIGGER_PKG dependencies on RA_INTERFACE_LINES_ALL

Line 244: FROM ra_interface_lines_all il

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:

Line 1304: v_ont_source_code ra_interface_lines_all.interface_line_context%type;

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:

Line 4331: v_ont_source_code ra_interface_lines_all.interface_line_context%type;

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: