DBA Data[Home] [Help]

APPS.IBY_TRANSACTIONCC_PKG dependencies on CE_SECURITY_PROFILES_V

Line 3086: * Join with CE_SECURITY_PROFILES_V for MOAC compliance.

3082: txn.batchid IS NULL AND
3083: /*
3084: * Fix for bug 5632947:
3085: *
3086: * Join with CE_SECURITY_PROFILES_V for MOAC compliance.
3087: */
3088: ((txn.org_id IS NULL) OR
3089: ((txn.org_id IS NOT NULL) AND
3090: (txn.org_id, txn.org_type) IN

Line 3095: ce_security_profiles_v ce

3091: (SELECT
3092: ce.organization_id,
3093: ce.organization_type
3094: FROM
3095: ce_security_profiles_v ce
3096: )))
3097: ORDER BY
3098: txn.process_profile_code, --
3099: txn.bepkey, -- Ensure that the

Line 3364: * Join with CE_SECURITY_PROFILES_V for MOAC compliance.

3360: || 'txn.batchid IS NULL AND '
3361: /*
3362: * Fix for bug 5632947:
3363: *
3364: * Join with CE_SECURITY_PROFILES_V for MOAC compliance.
3365: */
3366: || '((txn.org_id IS NULL) OR '
3367: || '((txn.org_id IS NOT NULL) AND '
3368: || '(txn.org_id, txn.org_type) IN '

Line 3373: || ' ce_security_profiles_v ce '

3369: || ' (SELECT '
3370: || ' ce.organization_id, '
3371: || ' ce.organization_type '
3372: || ' FROM '
3373: || ' ce_security_profiles_v ce '
3374: || ' ))) '
3375: || NVL (l_sql_str, 'AND 1=1 ')
3376: || 'ORDER BY '
3377: || 'txn.process_profile_code, ' --

Line 4204: * Join with CE_SECURITY_PROFILES_V for MOAC compliance.

4200: txn.batchid IS NULL AND
4201: /*
4202: * Fix for bug 5632947:
4203: *
4204: * Join with CE_SECURITY_PROFILES_V for MOAC compliance.
4205: */
4206: ((txn.org_id IS NULL) OR
4207: ((txn.org_id IS NOT NULL) AND
4208: (txn.org_id, txn.org_type) IN

Line 4213: ce_security_profiles_v ce

4209: (SELECT
4210: ce.organization_id,
4211: ce.organization_type
4212: FROM
4213: ce_security_profiles_v ce
4214: )))
4215: ORDER BY
4216: txn.process_profile_code, --
4217: txn.bepkey, -- Ensure that the

Line 4493: * Join with CE_SECURITY_PROFILES_V for MOAC compliance.

4489: || 'txn.batchid IS NULL AND '
4490: /*
4491: * Fix for bug 5632947:
4492: *
4493: * Join with CE_SECURITY_PROFILES_V for MOAC compliance.
4494: */
4495: || '((txn.org_id IS NULL) OR '
4496: || '((txn.org_id IS NOT NULL) AND '
4497: || '(txn.org_id, txn.org_type) IN '

Line 4502: || ' ce_security_profiles_v ce '

4498: || ' (SELECT '
4499: || ' ce.organization_id, '
4500: || ' ce.organization_type '
4501: || ' FROM '
4502: || ' ce_security_profiles_v ce '
4503: || ' ))) '
4504: || NVL (l_sql_str, 'AND 1=1 ')
4505: || 'ORDER BY '
4506: || 'txn.process_profile_code, ' --