DBA Data[Home] [Help]

APPS.JTF_RS_RESOURCE_UTL_PUB dependencies on JTF_RS_GROUP_MEMBERS

Line 137: , jtf_rs_group_members mem

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
141: AND rlt.role_resource_type = 'RS_GROUP_MEMBER'

Line 613: jtf_rs_group_members a

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'
617: AND b.role_resource_id = a.group_member_id

Line 642: jtf_rs_group_members a

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'
646: AND b.role_resource_id = a.group_member_id

Line 769: jtf_rs_group_members mem

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
773: AND rlt.role_resource_type = 'RS_GROUP_MEMBER'