eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CE_CEPURGE_XMLP_PKG dependencies on CE_SECURITY_PROFILES_GT

Line 77: CE_SECURITY_PROFILES_GT LBG

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

Line 308: CE_SECURITY_PROFILES_GT )

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

Line 313: CE_SECURITY_PROFILES_GT )

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;

Line 478: CE_SECURITY_PROFILES_GT LBG

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

Line 609: CE_SECURITY_PROFILES_GT LBG

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

Line 728: CE_SECURITY_PROFILES_GT LBG

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;

Line 922: CE_SECURITY_PROFILES_GT )

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

Line 927: CE_SECURITY_PROFILES_GT )

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;