APPS.CE_CEPURGE_XMLP_PKG dependencies on CE_INTRA_STMT_HEADERS

Line 90: CE_INTRA_STMT_HEADERS CSH

86: CURSOR C_PURGE_INTRA_HEADERS IS
87: SELECT
88: CSH.STATEMENT_HEADER_ID
89: FROM
90: CE_INTRA_STMT_HEADERS CSH
91: WHERE CSH.BANK_ACCOUNT_ID = NVL(P_BANK_ACCOUNT
92: ,BANK_ACCOUNT_ID)
93: AND CSH.BANK_ACCOUNT_ID IN (
94: SELECT

Line 1345: CE_INTRA_STMT_HEADERS CSH

1341: CREATION_DATE,
1342: LAST_UPDATED_BY,
1343: LAST_UPDATE_DATE
1344: FROM
1345: CE_INTRA_STMT_HEADERS CSH
1346: WHERE CSH.BANK_ACCOUNT_ID = P_BANK_ACCOUNT
1347: AND TRUNC(CSH.STATEMENT_DATE) >= NVL(P_STATEMENT_DATE_FROM
1348: ,TRUNC(CSH.STATEMENT_DATE))
1349: AND TRUNC(CSH.STATEMENT_DATE) <= NVL(P_STATEMENT_DATE_TO1

Line 1440: CE_INTRA_STMT_HEADERS CSH

1436: CREATION_DATE,
1437: LAST_UPDATED_BY,
1438: LAST_UPDATE_DATE
1439: FROM
1440: CE_INTRA_STMT_HEADERS CSH
1441: WHERE CSH.BANK_ACCOUNT_ID IN (
1442: SELECT
1443: ABA.BANK_ACCOUNT_ID
1444: FROM

Line 1540: CE_INTRA_STMT_HEADERS CSH

1536: CREATION_DATE,
1537: LAST_UPDATED_BY,
1538: LAST_UPDATE_DATE
1539: FROM
1540: CE_INTRA_STMT_HEADERS CSH
1541: WHERE TRUNC(CSH.STATEMENT_DATE) >= NVL(P_STATEMENT_DATE_FROM
1542: ,TRUNC(CSH.STATEMENT_DATE))
1543: AND TRUNC(CSH.STATEMENT_DATE) <= NVL(P_STATEMENT_DATE_TO1
1544: ,TRUNC(CSH.STATEMENT_DATE));

Line 1648: DELETE FROM CE_INTRA_STMT_HEADERS

1644: PURGE_HEADERS := 0;
1645: PURGE_LINES := 0;
1646: LOOP
1647: EXIT WHEN C_PURGE_INTRA_HEADERS%NOTFOUND;
1648: DELETE FROM CE_INTRA_STMT_HEADERS
1649: WHERE STATEMENT_HEADER_ID = X_HEADER_ID;
1650: PURGE_HEADERS := PURGE_HEADERS + SQL%ROWCOUNT;
1651: OPEN C_PURGE_INTRA_LINES;
1652: FETCH C_PURGE_INTRA_LINES