APPS.ASP_CONTACT_PREF_SECURITY_PUB dependencies on JTF_RS_REP_MANAGERS

Line 84: FROM jtf_rs_rep_managers jrrm ,

80: AND customer_id = Hr.object_id -- organization in the relationship
81: AND salesforce_id = res.resource_id)
82: AND NOT EXISTS (
83: SELECT jrrm.group_id,resource_id
84: FROM jtf_rs_rep_managers jrrm ,
85: jtf_rs_group_usages jrgu
86:
87: WHERE jrgu.usage in ('SALES', 'PRM')
88: AND jrgu.group_id = jrrm.group_id

Line 122: FROM JTF_RS_REP_MANAGERS jrrm,

118: AND res.source_id = per.person_id
119: AND PP.PARTY_ID = per.PARTY_ID
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

Line 146: FROM jtf_rs_rep_managers jrrm ,

142: AND customer_id = Hr.object_id -- organization in the relationship
143: AND salesforce_id = res.resource_id)
144: AND EXISTS (
145: SELECT jrrm.group_id,resource_id
146: FROM jtf_rs_rep_managers jrrm ,
147: jtf_rs_group_usages jrgu
148: WHERE jrgu.usage in ('SALES', 'PRM')
149: AND jrgu.group_id = jrrm.group_id
150: AND jrrm.start_date_active <= trunc(SYSDATE)