APPS.CE_PURGE dependencies on CE_INTRA_STMT_LINES

Line 1707: FROM ce_intra_stmt_lines

1703: CREATION_DATE,
1704: LAST_UPDATED_BY,
1705: LAST_UPDATE_DATE,
1706: RECONCILE_TO_STATEMENT_FLAG
1707: FROM ce_intra_stmt_lines
1708: WHERE statement_header_id IN
1709: ( SELECT statement_header_id
1710: FROM ce_arch_intra_headers );
1711:

Line 1819: FROM ce_intra_stmt_lines csl

1815:
1816: -- Cursor to purge the Intra day statement lines
1817: CURSOR C_PURGE_INTRA_LINES IS
1818: SELECT csl.statement_line_id
1819: FROM ce_intra_stmt_lines csl
1820: WHERE csl.statement_header_id = X_header_id;
1821:
1822: BEGIN
1823:

Line 1970: DELETE FROM ce_intra_stmt_lines

1966: FETCH C_PURGE_INTRA_LINES INTO X_line_id;
1967: LOOP
1968: EXIT WHEN c_purge_intra_lines%NOTFOUND;
1969:
1970: DELETE FROM ce_intra_stmt_lines
1971: WHERE statement_header_id = X_header_id;
1972: purge_lines := purge_lines + SQL%ROWCOUNT;
1973:
1974: FETCH C_PURGE_INTRA_LINES INTO X_line_id;

Line 2663: INSERT INTO ce_intra_stmt_lines

2659: IF l_DEBUG in ('Y', 'C') THEN
2660: cep_standard.debug('>> G_Archive_Stat_Headers2: '||G_Archive_Stat_Headers2);
2661: END IF;
2662:
2663: INSERT INTO ce_intra_stmt_lines
2664: (STATEMENT_LINE_ID,
2665: STATEMENT_HEADER_ID,
2666: LINE_NUMBER,
2667: TRX_DATE,