APPS.CE_CEPURGE_XMLP_PKG dependencies on CE_STATEMENT_HEADERS_INT

Line 1031: CE_STATEMENT_HEADERS_INT CSH

1027: CREATION_DATE,
1028: LAST_UPDATED_BY,
1029: LAST_UPDATE_DATE
1030: FROM
1031: CE_STATEMENT_HEADERS_INT CSH
1032: WHERE NVL(CSH.BANK_BRANCH_NAME
1033: ,C_BANK_BRANCH_NAME) IN (
1034: SELECT
1035: BB.BANK_BRANCH_NAME

Line 1170: CE_STATEMENT_HEADERS_INT CSH

1166: WHERE CSL.STATEMENT_NUMBER || '-' || CSL.BANK_ACCOUNT_NUM IN (
1167: SELECT
1168: CSH.STATEMENT_NUMBER || '-' || CSH.BANK_ACCOUNT_NUM
1169: FROM
1170: CE_STATEMENT_HEADERS_INT CSH
1171: WHERE NVL(CSH.BANK_BRANCH_NAME
1172: ,C_BANK_BRANCH_NAME) IN (
1173: SELECT
1174: BB.BANK_BRANCH_NAME

Line 1211: DELETE FROM CE_STATEMENT_HEADERS_INT CSH

1207: ,'T') )
1208: AND NVL(CSH.INTRA_DAY_FLAG
1209: ,'N') = 'N' );
1210: C_PURGE_INF_LINES := SQL%ROWCOUNT;
1211: DELETE FROM CE_STATEMENT_HEADERS_INT CSH
1212: WHERE NVL(CSH.BANK_BRANCH_NAME
1213: ,C_BANK_BRANCH_NAME) IN (
1214: SELECT
1215: BB.BANK_BRANCH_NAME

Line 1758: CE_STATEMENT_HEADERS_INT CSH

1754: LAST_UPDATED_BY,
1755: LAST_UPDATE_DATE,
1756: INTRA_DAY_FLAG
1757: FROM
1758: CE_STATEMENT_HEADERS_INT CSH
1759: WHERE NVL(CSH.BANK_BRANCH_NAME
1760: ,C_BANK_BRANCH_NAME) IN (
1761: SELECT
1762: BB.BANK_BRANCH_NAME

Line 1895: CE_STATEMENT_HEADERS_INT CSH

1891: WHERE CSL.STATEMENT_NUMBER || '-' || CSL.BANK_ACCOUNT_NUM IN (
1892: SELECT
1893: CSH.STATEMENT_NUMBER || '-' || CSH.BANK_ACCOUNT_NUM
1894: FROM
1895: CE_STATEMENT_HEADERS_INT CSH
1896: WHERE NVL(CSH.BANK_BRANCH_NAME
1897: ,C_BANK_BRANCH_NAME) IN (
1898: SELECT
1899: BB.BANK_BRANCH_NAME

Line 1935: DELETE FROM CE_STATEMENT_HEADERS_INT CSH

1931: ,RECORD_STATUS_FLAG
1932: ,'T') )
1933: AND CSH.INTRA_DAY_FLAG = 'Y' );
1934: C_PURGE_INF_LINES2 := SQL%ROWCOUNT;
1935: DELETE FROM CE_STATEMENT_HEADERS_INT CSH
1936: WHERE NVL(CSH.BANK_BRANCH_NAME
1937: ,C_BANK_BRANCH_NAME) IN (
1938: SELECT
1939: BB.BANK_BRANCH_NAME