APPS.CE_CEPURGE_XMLP_PKG dependencies on CE_STATEMENT_LINES_INTERFACE

Line 1149: CE_STATEMENT_LINES_INTERFACE CSL

1145: CHARGES_AMOUNT,
1146: CURRENCY_CODE,
1147: USER_EXCHANGE_RATE_TYPE
1148: FROM
1149: CE_STATEMENT_LINES_INTERFACE CSL
1150: WHERE CSL.BANK_ACCOUNT_NUM IN (
1151: SELECT
1152: BANK_ACCOUNT_NUM
1153: FROM

Line 1165: DELETE FROM CE_STATEMENT_LINES_INTERFACE CSL

1161: AND NVL(INTRA_DAY_FLAG
1162: ,'N') = 'N' );
1163: C_ARCHIVE_INF_LINES := SQL%ROWCOUNT;
1164: END IF;
1165: DELETE FROM CE_STATEMENT_LINES_INTERFACE CSL
1166: WHERE CSL.STATEMENT_NUMBER || '-' || CSL.BANK_ACCOUNT_NUM IN (
1167: SELECT
1168: CSH.STATEMENT_NUMBER || '-' || CSH.BANK_ACCOUNT_NUM
1169: FROM

Line 1875: CE_STATEMENT_LINES_INTERFACE CSL

1871: CHARGES_AMOUNT,
1872: CURRENCY_CODE,
1873: USER_EXCHANGE_RATE_TYPE
1874: FROM
1875: CE_STATEMENT_LINES_INTERFACE CSL
1876: WHERE CSL.BANK_ACCOUNT_NUM IN (
1877: SELECT
1878: BANK_ACCOUNT_NUM
1879: FROM

Line 1890: DELETE FROM CE_STATEMENT_LINES_INTERFACE CSL

1886: WHERE CSL.BANK_ACCOUNT_NUM = BANK_ACCOUNT_NUM
1887: AND INTRA_DAY_FLAG = 'Y' );
1888: C_ARCHIVE_INF_LINES2 := SQL%ROWCOUNT;
1889: END IF;
1890: DELETE FROM CE_STATEMENT_LINES_INTERFACE CSL
1891: WHERE CSL.STATEMENT_NUMBER || '-' || CSL.BANK_ACCOUNT_NUM IN (
1892: SELECT
1893: CSH.STATEMENT_NUMBER || '-' || CSH.BANK_ACCOUNT_NUM
1894: FROM