DBA Data[Home] [Help]

APPS.ENGECOBO dependencies on ORG_ACCESS

Line 6228: AND (NOT EXISTS(SELECT 1 FROM ORG_ACCESS acc

6224: -- expiration check
6225: AND org.organization_id = eclo.local_organization_id
6226: AND (org.date_to >= SYSDATE OR org.date_to IS NULL)
6227: -- inv security access check
6228: AND (NOT EXISTS(SELECT 1 FROM ORG_ACCESS acc
6229: WHERE acc.organization_id = eclo.local_organization_id )
6230: OR EXISTS(SELECT 1 FROM ORG_ACCESS acc
6231: WHERE acc.organization_id = eclo.local_organization_id
6232: AND acc.responsibility_id = TO_NUMBER(fnd_profile.value('RESP_ID'))));

Line 6230: OR EXISTS(SELECT 1 FROM ORG_ACCESS acc

6226: AND (org.date_to >= SYSDATE OR org.date_to IS NULL)
6227: -- inv security access check
6228: AND (NOT EXISTS(SELECT 1 FROM ORG_ACCESS acc
6229: WHERE acc.organization_id = eclo.local_organization_id )
6230: OR EXISTS(SELECT 1 FROM ORG_ACCESS acc
6231: WHERE acc.organization_id = eclo.local_organization_id
6232: AND acc.responsibility_id = TO_NUMBER(fnd_profile.value('RESP_ID'))));
6233: l_org_Idx NUMBER;
6234: l_orgs_Cnt NUMBER;