APPS.FV_DC_ASSIGN_FINANCE_CHRG dependencies on RA_INTERFACE_ERRORS

Line 225: from ra_interface_errors));

221: where name in (select distinct batch_source_name
222: from ra_interface_lines
223: where interface_line_context = 'Accrue Finance Charges'
224: and interface_line_id not in (select interface_line_id
225: from ra_interface_errors));
226:
227: /*****************************************************************************/
228: /* Variable Declarations For Assign Finance Charges */
229: /*****************************************************************************/

Line 1280: from ra_interface_errors);

1276: from ra_interface_lines
1277: where interface_line_context = 'Accrue Finance Charges'
1278: and batch_source_name = x_batch_source_name -- added line
1279: and interface_line_id not in (select interface_line_id
1280: from ra_interface_errors);
1281:
1282: begin
1283: l_module_name := g_module_name || 'cleanup';
1284:

Line 1299: from ra_interface_errors);

1295: delete from ra_interface_lines
1296: where interface_line_context = 'Accrue Finance Charges'
1297: and batch_source_name = var_batch_source_name -- added line
1298: and interface_line_id not in (select interface_line_id
1299: from ra_interface_errors);
1300:
1301: DELETE FROM fv_finchrg_debitmemo_temp -- Purge from temp table 2157100
1302: WHERE set_of_books_id=SOB_ID
1303: AND NVL(org_id,-99)=NVL(v_org_id,-99) ;

Line 1417: SELECT 1 FROM ra_interface_errors_all

1413: ) is
1414:
1415: l_module_name VARCHAR2(200);
1416: CURSOR RA_INTERFACE_ERR_CUR(p_sob number, p_org NUMBER) IS
1417: SELECT 1 FROM ra_interface_errors_all
1418: WHERE INTERFACE_LINE_ID IN
1419: (SELECT INTERFACE_LINE_ID
1420: FROM ra_interface_lines_all
1421: WHERE INTERFACE_LINE_CONTEXT='Accrue Finance Charges' AND