APPS.JAI_AR_RCTLA_TRIGGER_PKG dependencies on RA_INTERFACE_LINES_ALL

Line 270: FROM ra_interface_lines_all il

266: JAI_AR_TRXS trx
267: WHERE customer_trx_id = v_customer_trx_id
268: AND EXISTS
269: (SELECT 1
270: FROM ra_interface_lines_all il
271: WHERE il.customer_trx_id = v_customer_trx_id
272: AND NVL(il.interface_status , '~') <> 'P'
273: );
274:

Line 1375: v_ont_source_code ra_interface_lines_all.interface_line_context%type;

1371: */
1372: cursor c_ont_source_code is
1373: select FND_PROFILE.VALUE('ONT_SOURCE_CODE')
1374: from dual;
1375: v_ont_source_code ra_interface_lines_all.interface_line_context%type;
1376: /*
1377: ends here additions by sriram -bug#3607101
1378: */
1379:

Line 4662: v_ont_source_code ra_interface_lines_all.interface_line_context%type;

4658: */
4659: cursor c_ont_source_code is
4660: select FND_PROFILE.VALUE('ONT_SOURCE_CODE')
4661: from dual;
4662: v_ont_source_code ra_interface_lines_all.interface_line_context%type;
4663: /*
4664: ends here additions by sriram -bug#3680721
4665: */
4666: