DBA Data[Home] [Help]

APPS.ENGECOBO dependencies on ORG_ACCESS

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

5751: -- expiration check
5752: AND org.organization_id = eclo.local_organization_id
5753: AND (org.date_to >= SYSDATE OR org.date_to IS NULL)
5754: -- inv security access check
5755: AND (NOT EXISTS(SELECT 1 FROM ORG_ACCESS acc
5756: WHERE acc.organization_id = eclo.local_organization_id )
5757: OR EXISTS(SELECT 1 FROM ORG_ACCESS acc
5758: WHERE acc.organization_id = eclo.local_organization_id
5759: AND acc.responsibility_id = TO_NUMBER(fnd_profile.value('RESP_ID'))));

Line 5757: OR EXISTS(SELECT 1 FROM ORG_ACCESS acc

5753: AND (org.date_to >= SYSDATE OR org.date_to IS NULL)
5754: -- inv security access check
5755: AND (NOT EXISTS(SELECT 1 FROM ORG_ACCESS acc
5756: WHERE acc.organization_id = eclo.local_organization_id )
5757: OR EXISTS(SELECT 1 FROM ORG_ACCESS acc
5758: WHERE acc.organization_id = eclo.local_organization_id
5759: AND acc.responsibility_id = TO_NUMBER(fnd_profile.value('RESP_ID'))));
5760: l_org_Idx NUMBER;
5761: l_orgs_Cnt NUMBER;