APPS.PV_USER_MGMT_PVT dependencies on JTF_RS_ROLE_RELATIONS

Line 82: from jtf_rs_role_relations rr, jtf_rs_roles_b rrb

78:
79:
80: cursor c_get_role_relate_id(cv_resource_id NUMBER) is
81: select role_relate_id
82: from jtf_rs_role_relations rr, jtf_rs_roles_b rrb
83: where role_resource_id = cv_resource_id
84: and role_resource_type = 'RS_INDIVIDUAL'
85: and rr.start_date_active <= sysdate
86: and (rr.end_date_active is null or rr.end_date_active >=sysdate)

Line 102: from jtf_rs_role_relations rr, jtf_rs_roles_b rrb

98: and (delete_flag is null or delete_flag = 'N');
99:
100: cursor c_get_group_role_assigned (cv_group_member_id NUMBER) is
101: select role_relate_id
102: from jtf_rs_role_relations rr, jtf_rs_roles_b rrb
103: where role_resource_id = cv_group_member_id
104: and role_resource_type = 'RS_GROUP_MEMBER'
105: and rr.start_date_active <= sysdate
106: and (rr.end_date_active is null or rr.end_date_active >=sysdate)