APPS.CE_PURGE dependencies on CE_ARCH_RECON_ERRORS

Line 239: DELETE FROM CE_ARCH_RECON_ERRORS cre

235: IF( G_Archive_Purge_Option = 'Restore' ) THEN
236: G_Purge_Stat_Rec := SQL%ROWCOUNT;
237: END IF;
238:
239: DELETE FROM CE_ARCH_RECON_ERRORS cre
240: WHERE cre.statement_line_id IN (SELECT cah.statement_header_id
241: FROM ce_arch_headers cah ,
242: ce_statement_headers csh
243: WHERE cah.bank_account_id = csh.bank_account_id

Line 474: DELETE FROM CE_ARCH_RECON_ERRORS;

470: where org_id in (select org_id from ce_security_profiles_gt) or
471: legal_entity_id in (select org_id from ce_security_profiles_gt) or
472: REFERENCE_TYPE in ('JE_LINE', 'ROI_LINE','STATEMENT');
473:
474: DELETE FROM CE_ARCH_RECON_ERRORS;
475:
476: DELETE FROM CE_ARCH_LINES;
477:
478: DELETE FROM CE_ARCH_HEADERS;

Line 1062: INSERT INTO ce_arch_recon_errors

1058: ( SELECT statement_line_id
1059: FROM ce_arch_lines );
1060: G_Archive_Stat_Rec := SQL%ROWCOUNT;
1061:
1062: INSERT INTO ce_arch_recon_errors
1063: (STATEMENT_LINE_ID,
1064: MESSAGE_NAME,
1065: CREATION_DATE,
1066: CREATED_BY,

Line 2411: FROM ce_arch_recon_errors

2407: CREATION_DATE,
2408: CREATED_BY,
2409: APPLICATION_SHORT_NAME,
2410: STATEMENT_HEADER_ID
2411: FROM ce_arch_recon_errors
2412: WHERE statement_header_id = r_stmt.STATEMENT_HEADER_ID;
2413:
2414: G_Archive_Stat_Errors := SQL%ROWCOUNT;
2415:

Line 2437: DELETE FROM ce_arch_recon_errors

2433: ( SELECT statement_line_id
2434: FROM ce_arch_lines
2435: WHERE statement_header_id = r_stmt.STATEMENT_HEADER_ID );
2436:
2437: DELETE FROM ce_arch_recon_errors
2438: WHERE statement_header_id = r_stmt.STATEMENT_HEADER_ID;
2439:
2440: DELETE FROM ce_arch_lines
2441: WHERE statement_header_id = r_stmt.STATEMENT_HEADER_ID;