APPS.CE_CEPURGE_XMLP_PKG dependencies on CE_STATEMENT_RECONCILS_ALL

Line 52: CE_STATEMENT_RECONCILS_ALL SR

48: 1
49: FROM
50: CE_STATEMENT_HEADERS SH,
51: CE_STATEMENT_LINES SL,
52: CE_STATEMENT_RECONCILS_ALL SR
53: WHERE SH.STATEMENT_HEADER_ID = SL.STATEMENT_HEADER_ID
54: AND SL.STATEMENT_LINE_ID = SR.STATEMENT_LINE_ID
55: AND SH.STATEMENT_HEADER_ID = CSH.STATEMENT_HEADER_ID
56: AND SH.BANK_ACCOUNT_ID = NVL(P_BANK_ACCOUNT

Line 461: CE_STATEMENT_RECONCILS_ALL SR

457: 1
458: FROM
459: CE_STATEMENT_HEADERS SH,
460: CE_STATEMENT_LINES SL,
461: CE_STATEMENT_RECONCILS_ALL SR
462: WHERE SH.STATEMENT_HEADER_ID = SL.STATEMENT_HEADER_ID
463: AND SL.STATEMENT_LINE_ID = SR.STATEMENT_LINE_ID
464: AND SH.STATEMENT_HEADER_ID = CSH.STATEMENT_HEADER_ID
465: AND SH.BANK_ACCOUNT_ID = P_BANK_ACCOUNT

Line 587: CE_STATEMENT_RECONCILS_ALL SR

583: 1
584: FROM
585: CE_STATEMENT_HEADERS SH,
586: CE_STATEMENT_LINES SL,
587: CE_STATEMENT_RECONCILS_ALL SR
588: WHERE SH.STATEMENT_HEADER_ID = SL.STATEMENT_HEADER_ID
589: AND SL.STATEMENT_LINE_ID = SR.STATEMENT_LINE_ID
590: AND SH.STATEMENT_HEADER_ID = CSH.STATEMENT_HEADER_ID
591: AND SH.BANK_ACCOUNT_ID IN (

Line 712: CE_STATEMENT_RECONCILS_ALL SR

708: 1
709: FROM
710: CE_STATEMENT_HEADERS SH,
711: CE_STATEMENT_LINES SL,
712: CE_STATEMENT_RECONCILS_ALL SR
713: WHERE SH.STATEMENT_HEADER_ID = SL.STATEMENT_HEADER_ID
714: AND SL.STATEMENT_LINE_ID = SR.STATEMENT_LINE_ID
715: AND SH.STATEMENT_HEADER_ID = CSH.STATEMENT_HEADER_ID
716: AND SH.STATEMENT_DATE >= NVL(P_STATEMENT_DATE_FROM

Line 916: DELETE FROM CE_STATEMENT_RECONCILS_ALL

912: EXIT WHEN C_PURGE_LINES%NOTFOUND;
913: DELETE FROM CE_STATEMENT_LINES
914: WHERE STATEMENT_HEADER_ID = X_HEADER_ID;
915: PURGE_LINES := PURGE_LINES + SQL%ROWCOUNT;
916: DELETE FROM CE_STATEMENT_RECONCILS_ALL
917: WHERE STATEMENT_LINE_ID = X_LINE_ID
918: AND ( ORG_ID in (
919: SELECT
920: ORGANIZATION_ID