73: AND not exists (
74: SELECT
75: 1
76: FROM
77: CE_SECURITY_PROFILES_GT LBG
78: WHERE LBG.ORGANIZATION_ID = SR.ORG_ID
79: OR SR.LEGAL_ENTITY_ID = LBG.ORGANIZATION_ID ) );
80: CURSOR C_PURGE_LINES IS
81: SELECT
304: WHERE ORG_ID in (
305: SELECT
306: ORG_ID
307: FROM
308: CE_SECURITY_PROFILES_GT )
309: OR LEGAL_ENTITY_ID in (
310: SELECT
311: ORG_ID
312: FROM
309: OR LEGAL_ENTITY_ID in (
310: SELECT
311: ORG_ID
312: FROM
313: CE_SECURITY_PROFILES_GT )
314: OR REFERENCE_TYPE in ( 'JE_LINE' , 'ROI_LINE' , 'STATEMENT' );
315: END IF;
316: IF (COUNT_ERRORS > 0) THEN
317: DELETE FROM CE_ARCH_RECON_ERRORS;
474: AND not exists (
475: SELECT
476: 1
477: FROM
478: CE_SECURITY_PROFILES_GT LBG
479: WHERE LBG.ORGANIZATION_ID = SR.ORG_ID
480: OR SR.LEGAL_ENTITY_ID = LBG.ORGANIZATION_ID ) );
481: C_ARCHIVE_STAT_HEADERS := SQL%ROWCOUNT;
482: ELSIF (P_BANK_BRANCH IS NOT NULL) THEN
605: AND not exists (
606: SELECT
607: 1
608: FROM
609: CE_SECURITY_PROFILES_GT LBG
610: WHERE LBG.ORGANIZATION_ID = SR.ORG_ID
611: OR SR.LEGAL_ENTITY_ID = LBG.ORGANIZATION_ID ) );
612: C_ARCHIVE_STAT_HEADERS := SQL%ROWCOUNT;
613: ELSE
724: AND not exists (
725: SELECT
726: 1
727: FROM
728: CE_SECURITY_PROFILES_GT LBG
729: WHERE LBG.ORGANIZATION_ID = SR.ORG_ID
730: OR SR.LEGAL_ENTITY_ID = LBG.ORGANIZATION_ID ) );
731: C_ARCHIVE_STAT_HEADERS := SQL%ROWCOUNT;
732: END IF;
918: AND ( ORG_ID in (
919: SELECT
920: ORGANIZATION_ID
921: FROM
922: CE_SECURITY_PROFILES_GT )
923: OR LEGAL_ENTITY_ID in (
924: SELECT
925: ORGANIZATION_ID
926: FROM
923: OR LEGAL_ENTITY_ID in (
924: SELECT
925: ORGANIZATION_ID
926: FROM
927: CE_SECURITY_PROFILES_GT )
928: OR REFERENCE_TYPE in ( 'JE_LINE' , 'ROI_LINE' , 'STATEMENT' ) );
929: PURGE_RECONS := PURGE_RECONS + SQL%ROWCOUNT;
930: DELETE FROM CE_RECONCILIATION_ERRORS
931: WHERE STATEMENT_LINE_ID = X_LINE_ID;