APPS.CE_PURGE dependencies on CE_ARCH_RECONCILIATIONS

Line 219: DELETE FROM CE_ARCH_RECONCILIATIONS car

215: BEGIN
216: IF (G_STATEMENT_TYPE IN ('BOTH','PREVIOUS')) THEN
217: IF (G_OBJECTS IN ('BOTH','STATEMENT')) THEN
218:
219: DELETE FROM CE_ARCH_RECONCILIATIONS car
220: WHERE car.statement_line_id IN
221: (SELECT cl.statement_line_id FROM ce_arch_lines cl WHERE
222: cl.statement_header_id IN (SELECT cah.statement_header_id
223: FROM ce_arch_headers cah ,

Line 469: DELETE FROM CE_ARCH_RECONCILIATIONS_all

465: BEGIN
466: IF (G_STATEMENT_TYPE IN ('BOTH','PREVIOUS')) THEN
467: IF (G_OBJECTS IN ('BOTH','STATEMENT')) THEN
468:
469: DELETE FROM CE_ARCH_RECONCILIATIONS_all
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:

Line 1014: INSERT INTO ce_arch_reconciliations_all

1010: ( SELECT statement_header_id
1011: FROM ce_arch_headers );
1012: G_Archive_Stat_Lines := SQL%ROWCOUNT;
1013:
1014: INSERT INTO ce_arch_reconciliations_all
1015: (STATEMENT_LINE_ID,
1016: REFERENCE_TYPE,
1017: REFERENCE_ID,
1018: JE_HEADER_ID,

Line 2114: from ce_arch_headers sh, ce_arch_lines sl , ce_arch_reconciliations_all sr

2110: AND csh.statement_date >= NVL(CE_PURGE.G_STATEMENT_DATE_FROM, csh.statement_date)
2111: AND csh.statement_date <= NVL(CE_PURGE.G_STATEMENT_DATE_TO, csh.statement_date)
2112: AND not exists
2113: (select 1 -- find all stmts that are not in ce_security_profiles_gt (cannot delete these stmts)
2114: from ce_arch_headers sh, ce_arch_lines sl , ce_arch_reconciliations_all sr
2115: where sh.statement_header_id = sl.statement_header_id
2116: and sl.statement_line_id= sr.statement_line_id
2117: and sh.statement_header_id= csh.statement_header_id
2118: and ( csh.bank_account_id = Nvl(CE_PURGE.G_BANK_ACCOUNT_ID,-1)

Line 2387: FROM ce_arch_reconciliations_all --ce_statement_reconciliations

2383: PROGRAM_APPLICATION_ID,
2384: PROGRAM_ID,
2385: PROGRAM_UPDATE_DATE,
2386: AMOUNT
2387: FROM ce_arch_reconciliations_all --ce_statement_reconciliations
2388: WHERE statement_line_id IN
2389: ( SELECT statement_line_id
2390: FROM ce_arch_lines
2391: WHERE statement_header_id = r_stmt.STATEMENT_HEADER_ID );

Line 2431: DELETE FROM ce_arch_reconciliations_all --ce_statement_reconciliations

2427: put_endtag('StmtRestored') ;
2428:
2429: /*Delete Restored Statements*/
2430:
2431: DELETE FROM ce_arch_reconciliations_all --ce_statement_reconciliations
2432: WHERE statement_line_id IN
2433: ( SELECT statement_line_id
2434: FROM ce_arch_lines
2435: WHERE statement_header_id = r_stmt.STATEMENT_HEADER_ID );