APPS.CE_PURGE dependencies on CE_STATEMENT_LINES_INTERFACE

Line 1286: FROM ce_statement_lines_interface csl

1282: AMOUNT,
1283: CHARGES_AMOUNT,
1284: CURRENCY_CODE,
1285: USER_EXCHANGE_RATE_TYPE
1286: FROM ce_statement_lines_interface csl
1287: WHERE csl.statement_number ||'-'|| csl.bank_account_num IN (
1288: SELECT csh.statement_number ||'-'|| csh.bank_account_num
1289: FROM ce_statement_headers_int csh
1290: WHERE NVL(csh.bank_branch_name,CE_PURGE.G_BANK_BRANCH_NAME) IN (SELECT bb.bank_branch_name

Line 1900: DELETE FROM ce_statement_lines_interface csl

1896: IF (CE_PURGE.G_Archive_Purge_Option = 'BOTH')THEN
1897: arch_ce_interface('N');
1898: END IF;
1899:
1900: DELETE FROM ce_statement_lines_interface csl
1901: WHERE csl.statement_number ||'-'|| csl.bank_account_num IN
1902: ( SELECT csh.statement_number ||'-'|| csh.bank_account_num
1903: FROM ce_statement_headers_int csh
1904: WHERE NVL(csh.bank_branch_name,CE_PURGE.G_BANK_BRANCH_NAME) IN (SELECT bb.bank_branch_name

Line 1995: DELETE FROM ce_statement_lines_interface csl

1991: IF (CE_PURGE.G_Archive_Purge_Option = 'BOTH')THEN
1992: arch_ce_interface('Y');
1993: END IF;
1994:
1995: DELETE FROM ce_statement_lines_interface csl
1996: WHERE csl.statement_number ||'-'|| csl.bank_account_num IN
1997: ( SELECT csh.statement_number ||'-'|| csh.bank_account_num
1998: FROM ce_statement_headers_int csh
1999: WHERE NVL(csh.bank_branch_name,CE_PURGE.G_BANK_BRANCH_NAME) IN (SELECT bb.bank_branch_name

Line 3021: INSERT INTO ce_statement_lines_interface

3017: G_Archive_Inf_Headers2 := G_Archive_Inf_Headers2 + SQL%ROWCOUNT;
3018: END IF;
3019:
3020:
3021: INSERT INTO ce_statement_lines_interface
3022: (EXCHANGE_RATE_DATE,
3023: EXCHANGE_RATE,
3024: BANK_TRX_NUMBER,
3025: CUSTOMER_TEXT,