eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSM_EMAIL_QUERY_PKG dependencies on JTF_RS_ROLES_B

Line 57: jtf_rs_roles_b rb,

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
61: AND rr.ROLE_ID = rb.ROLE_ID

Line 233: jtf_rs_roles_b rb,

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
237: AND rr.ROLE_ID = rb.ROLE_ID

Line 261: jtf_rs_roles_b rb,

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)
265: and RR.DELETE_FLAG = 'N'

Line 587: jtf_rs_roles_b rb,

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

Line 632: jtf_rs_roles_b rb,

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
636: gb.group_id = p_group_id

Line 665: jtf_rs_roles_b rb

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
669: AND rb.ROLE_TYPE_CODE ='CSF_THIRD_PARTY'

Line 954: jtf_rs_roles_b rb,

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
958: AND rr.ROLE_ID = rb.ROLE_ID

Line 1879: jtf_rs_roles_b rb,

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
1883: AND rr.ROLE_ID = rb.ROLE_ID

Line 1907: jtf_rs_roles_b rb,

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
1911: AND rr.ROLE_ID = rb.ROLE_ID