APPS.CSM_EMAIL_QUERY_PKG dependencies on JTF_RS_ROLE_RELATIONS

Line 56: from jtf_rs_role_relations rr,

52: IS
53: CURSOR c_get_groups(p_resource_id NUMBER)
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

Line 232: jtf_rs_role_relations rr,

228:
229: CURSOR c_grp_task_assignment( p_resource_id NUMBER, p_task_number VARCHAR2)
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

Line 260: from jtf_rs_role_relations rr,

256: and JTB.TASK_ID = JTA.TASK_ID
257: and JTA.RESOURCE_ID = JTM.RESOURCE_ID
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)

Line 588: jtf_rs_role_relations rr_grp,

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
591: AND gm.resource_id = rs.resource_id
592: AND gm.delete_flag = 'N'

Line 589: jtf_rs_role_relations rr_res

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
591: AND gm.resource_id = rs.resource_id
592: AND gm.delete_flag = 'N'
593: AND gm.group_id = gb.group_id

Line 633: jtf_rs_role_relations rr_grp,

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
636: gb.group_id = p_group_id
637: AND gb.start_date_active <= sysdate

Line 634: jtf_rs_role_relations rr_res

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
636: gb.group_id = p_group_id
637: AND gb.start_date_active <= sysdate
638: AND(gb.end_date_active IS NULL OR gb.end_date_active >= sysdate)

Line 664: jtf_rs_role_relations rr,

660: --Check if a given group has third party provider role assigned
661: CURSOR c_third_party_group (p_group_id NUMBER)
662: IS
663: select 1 from
664: jtf_rs_role_relations rr,
665: jtf_rs_roles_b rb
666: WHERE rr.ROLE_RESOURCE_TYPE ='RS_GROUP'
667: AND rr.ROLE_RESOURCE_ID = p_group_id
668: AND rr.ROLE_ID = rb.ROLE_ID

Line 953: jtf_rs_role_relations rr,

949: WHERE jtb.task_number = p_task_number
950: AND jtb.task_id = jta.task_id
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

Line 1878: jtf_rs_role_relations rr,

1874: AND tsk.source_object_type_code = 'SR'
1875: AND ass.task_id = tsk.task_id
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

Line 1906: jtf_rs_role_relations rr,

1902: and ASS.TASK_ID = TSK.TASK_ID
1903: and ASS.RESOURCE_TYPE_CODE ='RS_EMPLOYEE'
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