[Home] [Help]
332: res.category resource_category,
333: m.group_id group_id
334: FROM jtf_rs_groups_b g,
335: jtf_rs_group_usages u,
336: jtf_rs_group_members m,
337: jtf_rs_role_relations rr,
338: jtf_rs_roles_b r,
339: jtf_rs_resource_extns res
340: WHERE g.group_id = l_resource_group_id
388: jtf_rs_resource_extns tres,
389: (
390: SELECT m.group_id group_id,
391: m.resource_id resource_id
392: FROM jtf_rs_group_members m,
393: jtf_rs_groups_b g,
394: jtf_rs_group_usages u,
395: jtf_rs_role_relations rr,
396: jtf_rs_roles_b r,
438: min(m.person_id) person_id,
439: min(m.group_id) group_id,
440: min(jtm.team_id) team_id,
441: res.category resource_category
442: FROM jtf_rs_group_members m,
443: jtf_rs_groups_b g,
444: jtf_rs_group_usages u,
445: jtf_rs_role_relations rr,
446: jtf_rs_roles_b r,
671: /* PINAGARA: Introduced jtf_rs_groups_b table as bug fix for 4869726 */
672: CURSOR l_res_is_vendor_CM_csr(cv_resource_id NUMBER) IS
673: SELECT 'Y'
674: FROM jtf_rs_resource_extns RES,
675: jtf_rs_group_members GRPMEM,
676: jtf_rs_group_usages GRPUSG,
677: jtf_rs_role_relations ROLRELAT ,
678: jtf_rs_roles_vl ROLE,
679: jtf_rs_groups_b b
784: nvl(RES.end_date_active,sysdate)
785: AND RES.resource_id IN (
786: SELECT GRPMEM.resource_id
787: FROM
788: jtf_rs_group_members GRPMEM,
789: jtf_rs_groups_b GROUPB,
790: jtf_rs_group_usages GRPUSG,
791: jtf_rs_role_relations ROLRELAT ,
792: jtf_rs_roles_vl ROLE
4649: FROM
4650: hz_relationships HZPR_PART_CONT ,
4651: hz_parties CONTACT ,
4652: jtf_rs_resource_extns RES ,
4653: jtf_rs_group_members GRPMEM,
4654: jtf_rs_group_usages GRPUSG,
4655: jtf_rs_role_relations ROLRELAT ,
4656: jtf_rs_roles_vl ROLE
4657: WHERE HZPR_PART_CONT.RELATIONSHIP_TYPE = 'EMPLOYMENT'