APPS.ASP_CONTACT_PREF_SECURITY_PUB dependencies on AS_ACCESSES_ALL

Line 77: FROM as_accesses_all

73: AND res.source_id = per.person_id
74: AND PP.PARTY_ID = per.PARTY_ID
75: AND NOT EXISTS(
76: SELECT 1
77: FROM as_accesses_all
78: WHERE sales_lead_id IS NULL
79: AND lead_id IS NULL
80: AND customer_id = Hr.object_id -- organization in the relationship
81: AND salesforce_id = res.resource_id)

Line 124: AS_ACCESSES_ALL aaa

120: AND NOT EXISTS(
121: SELECT 1
122: FROM JTF_RS_REP_MANAGERS jrrm,
123: JTF_RS_GROUP_USAGES jrgu,
124: AS_ACCESSES_ALL aaa
125: WHERE jrgu.usage IN ('SALES', 'PRM')
126: AND jrgu.group_id = jrrm.group_id
127: AND jrrm.hierarchy_type IN ('MGR_TO_MGR', 'MGR_TO_REP')
128: AND jrrm.resource_id = aaa.salesforce_id

Line 139: FROM as_accesses_all

135: AND jrrm.parent_resource_id = res.resource_id
136: AND jrrm.parent_resource_id <> jrrm.resource_id
137: UNION ALL
138: SELECT 1
139: FROM as_accesses_all
140: WHERE sales_lead_id IS NULL
141: AND lead_id IS NULL
142: AND customer_id = Hr.object_id -- organization in the relationship
143: AND salesforce_id = res.resource_id)