APPS.JTF_RS_RESOURCE_UTL_PUB dependencies on JTF_RS_ROLE_RELATIONS

Line 46: CURSOR res_role_cur(l_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE)

42: term_res_rec term_res_cur%rowtype;
43:
44:
45: --cursor to get group member roles for the resource
46: CURSOR res_role_cur(l_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE)
47: IS
48: SELECT rlt.role_relate_id
49: , rlt.start_date_active
50: , rlt.end_date_active

Line 52: FROM jtf_rs_role_relations rlt

48: SELECT rlt.role_relate_id
49: , rlt.start_date_active
50: , rlt.end_date_active
51: , rlt.object_version_number
52: FROM jtf_rs_role_relations rlt
53: WHERE rlt.role_resource_id = l_role_resource_id
54: AND rlt.role_resource_type = 'RS_INDIVIDUAL'
55: AND nvl(rlt.delete_flag, 'N') <> 'Y'
56: -- AND nvl(rlt.end_date_active,trunc(sysdate)) >= trunc(sysdate);

Line 116: FROM jtf_rs_role_relations rlt

112: SELECT rlt.role_relate_id
113: , rlt.start_date_active
114: , rlt.end_date_active
115: , rlt.object_version_number
116: FROM jtf_rs_role_relations rlt
117: , jtf_rs_team_members mem
118: WHERE mem.team_resource_id = l_resource_id
119: AND mem.resource_type = 'INDIVIDUAL'
120: AND nvl(mem.delete_flag, 'N') <> 'Y'

Line 136: FROM jtf_rs_role_relations rlt

132: SELECT rlt.role_relate_id
133: , rlt.start_date_active
134: , rlt.end_date_active
135: , rlt.object_version_number
136: FROM jtf_rs_role_relations rlt
137: , jtf_rs_group_members mem
138: WHERE mem.resource_id = l_resource_id
139: AND nvl(mem.delete_flag, 'N') <> 'Y'
140: AND rlt.role_resource_id = mem.group_member_id

Line 612: jtf_rs_role_relations b,

608: BEGIN
609: SELECT '1'
610: INTO l_mgr
611: FROM jtf_rs_roles_b c,
612: jtf_rs_role_relations b,
613: jtf_rs_group_members a
614: WHERE a.group_id = parent_grp_rec.parent_group_id
615: AND a.resource_id = l_resource_id
616: AND nvl(a.delete_flag, 'N') <> 'Y'

Line 641: jtf_rs_role_relations b,

637: BEGIN
638: SELECT '2'
639: INTO l_mgr
640: FROM jtf_rs_roles_b c,
641: jtf_rs_role_relations b,
642: jtf_rs_group_members a
643: WHERE a.group_id = p_group_id
644: AND a.resource_id = l_resource_id
645: AND nvl(a.delete_flag, 'N') <> 'Y'

Line 768: FROM jtf_rs_role_relations rlt,

764: SELECT rlt.role_relate_id,
765: rlt.start_date_active,
766: rlt.end_date_active,
767: rlt.object_version_number
768: FROM jtf_rs_role_relations rlt,
769: jtf_rs_group_members mem
770: WHERE mem.group_id = c_group_id
771: AND nvl(mem.delete_flag, 'N') <> 'Y'
772: AND rlt.role_resource_id = mem.group_member_id

Line 781: FROM jtf_rs_role_relations rlt2

777: SELECT rlt2.role_relate_id,
778: rlt2.start_date_active,
779: rlt2.end_date_active,
780: rlt2.object_version_number
781: FROM jtf_rs_role_relations rlt2
782: WHERE rlt2.role_resource_id = c_group_id
783: AND rlt2.role_resource_type = 'RS_GROUP'
784: AND nvl(rlt2.delete_flag ,'N') <> 'Y'
785: AND NVL(rlt2.end_date_active, l_fnd_date) > c_group_end_date;