APPS.CSM_RESOURCE_EXTNS_EVENT_PKG dependencies on JTF_RS_GROUP_MEMBERS

Line 181: FROM jtf_rs_group_members jtf_rs_grp,

177: --12.1
178: CURSOR c_grp_members(p_resource_id NUMBER, p_user_id NUMBER) IS --insert prof2
179: SELECT DISTINCT jtf_rs.user_id,
180: jtf_rs.resource_id
181: FROM jtf_rs_group_members jtf_rs_grp,
182: jtf_rs_resource_extns jtf_rs
183: WHERE EXISTS (SELECT 1
184: FROM jtf_rs_group_members
185: WHERE group_id = jtf_rs_grp.group_id

Line 184: FROM jtf_rs_group_members

180: jtf_rs.resource_id
181: FROM jtf_rs_group_members jtf_rs_grp,
182: jtf_rs_resource_extns jtf_rs
183: WHERE EXISTS (SELECT 1
184: FROM jtf_rs_group_members
185: WHERE group_id = jtf_rs_grp.group_id
186: AND resource_id = p_resource_id
187: AND delete_flag = 'N')
188: AND jtf_rs.resource_id = jtf_rs_grp.resource_id

Line 203: FROM jtf_rs_group_members jtf_rs_grp,

199: SELECT resource_id
200: FROM CSM_RS_RESOURCE_EXTNS_ACC ACC
201: WHERE acc.user_id=p_user_id
202: AND NOT EXISTS ( SELECT 1
203: FROM jtf_rs_group_members jtf_rs_grp,
204: jtf_rs_resource_extns valid_fnd_user
205: WHERE EXISTS (SELECT 1
206: FROM jtf_rs_group_members
207: WHERE group_id = jtf_rs_grp.group_id

Line 206: FROM jtf_rs_group_members

202: AND NOT EXISTS ( SELECT 1
203: FROM jtf_rs_group_members jtf_rs_grp,
204: jtf_rs_resource_extns valid_fnd_user
205: WHERE EXISTS (SELECT 1
206: FROM jtf_rs_group_members
207: WHERE group_id = jtf_rs_grp.group_id
208: AND resource_id = p_resource_id
209: AND delete_flag = 'N')
210: AND jtf_rs_grp.resource_id= Acc.resource_id

Line 325: CURSOR c_grp_palm_members (p_resource_id jtf_rs_group_members.resource_id%TYPE) IS

321: --Bug 5236469
322: PROCEDURE RESOURCE_EXTNS_ACC_PROCESSOR (p_resource_id IN NUMBER, p_user_id IN NUMBER)
323: IS
324: -- Cursor to get grp members
325: CURSOR c_grp_palm_members (p_resource_id jtf_rs_group_members.resource_id%TYPE) IS
326: SELECT DISTINCT au.user_id,
327: au.resource_id
328: FROM jtf_rs_group_members jtf_rs_grp,
329: ASG_user au,

Line 328: FROM jtf_rs_group_members jtf_rs_grp,

324: -- Cursor to get grp members
325: CURSOR c_grp_palm_members (p_resource_id jtf_rs_group_members.resource_id%TYPE) IS
326: SELECT DISTINCT au.user_id,
327: au.resource_id
328: FROM jtf_rs_group_members jtf_rs_grp,
329: ASG_user au,
330: ASG_USER_PUB_RESPS aupr
331: WHERE EXISTS (SELECT 1
332: FROM jtf_rs_group_members

Line 332: FROM jtf_rs_group_members

328: FROM jtf_rs_group_members jtf_rs_grp,
329: ASG_user au,
330: ASG_USER_PUB_RESPS aupr
331: WHERE EXISTS (SELECT 1
332: FROM jtf_rs_group_members
333: WHERE group_id = jtf_rs_grp.group_id
334: AND resource_id = p_resource_id
335: AND delete_flag = 'N')
336: AND jtf_rs_grp.resource_id=au.resource_id

Line 343: CURSOR c_all_mfs_users(p_resource_id jtf_rs_group_members.resource_id%TYPE) IS

339: AND au.USER_NAME=aupr.USER_NAME
340: AND aupr.PUB_NAME='SERVICEP';
341:
342:
343: CURSOR c_all_mfs_users(p_resource_id jtf_rs_group_members.resource_id%TYPE) IS
344: SELECT AU.user_id,AU.resource_id
345: FROM ASG_USER AU,
346: ASG_USER_PUB_RESPS aupr
347: WHERE AU.ENABLED='Y'

Line 412: FROM jtf_rs_group_members grp,

408:
409: CURSOR l_group_members_csr(p_group_id IN number, p_resource_id IN number)
410: IS
411: SELECT au.resource_id, au.user_id
412: FROM jtf_rs_group_members grp,
413: asg_user au,
414: asg_user_pub_resps aupr
415: WHERE grp.group_id = p_group_id
416: AND grp.resource_id = au.resource_id

Line 492: FROM jtf_rs_group_members grp,

488:
489: CURSOR l_group_members_csr(p_group_id IN number, p_resource_id IN number)
490: IS
491: SELECT au.resource_id, au.user_id
492: FROM jtf_rs_group_members grp,
493: asg_user au,
494: asg_user_pub_resps aupr
495: WHERE grp.group_id = p_group_id
496: AND grp.resource_id = au.resource_id