APPS.CSM_EMAIL_QUERY_PKG dependencies on JTF_RS_GROUP_MEMBERS

Line 58: jtf_rs_group_members gm

54: IS
55: select gm.GROUP_ID
56: from jtf_rs_role_relations rr,
57: jtf_rs_roles_b rb,
58: jtf_rs_group_members gm
59: WHERE rr.ROLE_RESOURCE_TYPE ='RS_INDIVIDUAL'
60: AND rr.ROLE_RESOURCE_ID = p_resource_id
61: AND rr.ROLE_ID = rb.ROLE_ID
62: AND rb.ROLE_TYPE_CODE ='CSF_THIRD_PARTY'

Line 234: jtf_rs_group_members gm

230: IS
231: select 1 from
232: jtf_rs_role_relations rr,
233: jtf_rs_roles_b rb,
234: jtf_rs_group_members gm
235: WHERE rr.ROLE_RESOURCE_TYPE ='RS_INDIVIDUAL'
236: AND rr.ROLE_RESOURCE_ID = p_resource_id
237: AND rr.ROLE_ID = rb.ROLE_ID
238: AND rb.ROLE_TYPE_CODE ='CSF_THIRD_PARTY'

Line 254: JTF_RS_GROUP_MEMBERS jtm

250: IS
251: SELECT count(*) over () row_count
252: from JTF_TASK_ASSIGNMENTS JTA,
253: JTF_TASKS_B JTB,
254: JTF_RS_GROUP_MEMBERS jtm
255: WHERE jtb.task_number = p_task_number
256: and JTB.TASK_ID = JTA.TASK_ID
257: and JTA.RESOURCE_ID = JTM.RESOURCE_ID
258: and JTM.DELETE_FLAG = 'N'

Line 262: jtf_rs_group_members gm

258: and JTM.DELETE_FLAG = 'N'
259: AND jtm.GROUP_ID IN( select gm.GROUP_ID
260: from jtf_rs_role_relations rr,
261: jtf_rs_roles_b rb,
262: jtf_rs_group_members gm
263: where RR.ROLE_RESOURCE_TYPE ='RS_INDIVIDUAL'
264: and sysdate between NVL(RR.START_DATE_ACTIVE,sysdate) and NVL(RR.END_DATE_ACTIVE,sysdate)
265: and RR.DELETE_FLAG = 'N'
266: and gm.DELETE_FLAG = 'N'

Line 586: jtf_rs_group_members gm,

582: gtl.group_name
583: FROM jtf_rs_resource_extns rs,
584: jtf_rs_groups_b gb,
585: jtf_rs_groups_tl gtl,
586: jtf_rs_group_members gm,
587: jtf_rs_roles_b rb,
588: jtf_rs_role_relations rr_grp,
589: jtf_rs_role_relations rr_res
590: WHERE rs.user_id = p_user_id

Line 617: JTF_RS_GROUP_MEMBERS GM

613: is
614: SELECT fusr.user_id
615: from FND_USER FUSR,
616: JTF_RS_RESOURCE_EXTNS RS,
617: JTF_RS_GROUP_MEMBERS GM
618: where gm.group_id = p_group_id
619: AND gm.delete_flag = 'N'
620: AND rs.resource_id = gm.resource_id
621: AND rs.start_date_active <= sysdate

Line 631: JTF_RS_GROUP_MEMBERS GM

627: /* SELECT fusr.user_id
628: from FND_USER FUSR,
629: JTF_RS_RESOURCE_EXTNS RS,
630: jtf_rs_groups_b gb,
631: JTF_RS_GROUP_MEMBERS GM
632: jtf_rs_roles_b rb,
633: jtf_rs_role_relations rr_grp,
634: jtf_rs_role_relations rr_res
635: where AND gm.group_id = p_group_id

Line 955: jtf_rs_group_members gm

951: AND jta.resource_type_code ='RS_GROUP'
952: AND jta.resource_id IN ( SELECT gm.GROUP_ID from
953: jtf_rs_role_relations rr,
954: jtf_rs_roles_b rb,
955: jtf_rs_group_members gm
956: WHERE rr.ROLE_RESOURCE_TYPE ='RS_INDIVIDUAL'
957: AND rr.ROLE_RESOURCE_ID = p_resource_id
958: AND rr.ROLE_ID = rb.ROLE_ID
959: AND rb.ROLE_TYPE_CODE ='CSF_THIRD_PARTY'

Line 1880: jtf_rs_group_members gm

1876: AND ass.resource_type_code ='RS_GROUP'
1877: AND ass.resource_id IN( SELECT gm.GROUP_ID from
1878: jtf_rs_role_relations rr,
1879: jtf_rs_roles_b rb,
1880: jtf_rs_group_members gm
1881: WHERE rr.ROLE_RESOURCE_TYPE ='RS_INDIVIDUAL'
1882: AND rr.ROLE_RESOURCE_ID = p_resource_id
1883: AND rr.ROLE_ID = rb.ROLE_ID
1884: AND rb.ROLE_TYPE_CODE ='CSF_THIRD_PARTY'

Line 1897: JTF_RS_GROUP_MEMBERS jtm

1893: FROM csi_item_instances csi,
1894: cs_incidents_all_b cs,
1895: jtf_tasks_b tsk,
1896: JTF_TASK_ASSIGNMENTS ASS,
1897: JTF_RS_GROUP_MEMBERS jtm
1898: WHERE csi.serial_number = p_serial_number
1899: AND csi.instance_id = cs.customer_product_id
1900: AND tsk.source_object_id = cs.incident_id
1901: AND tsk.source_object_type_code = 'SR'

Line 1908: jtf_rs_group_members gm

1904: and ASS.RESOURCE_ID = JTM.RESOURCE_ID
1905: AND jtm.GROUP_ID IN( SELECT gm.GROUP_ID from
1906: jtf_rs_role_relations rr,
1907: jtf_rs_roles_b rb,
1908: jtf_rs_group_members gm
1909: WHERE rr.ROLE_RESOURCE_TYPE ='RS_INDIVIDUAL'
1910: AND rr.ROLE_RESOURCE_ID = p_resource_id
1911: AND rr.ROLE_ID = rb.ROLE_ID
1912: AND rb.ROLE_TYPE_CODE ='CSF_THIRD_PARTY'