APPS.PV_TERR_ASSIGN_PUB dependencies on JTF_RS_GROUP_USAGES

Line 335: jtf_rs_group_usages u,

331: m.person_id person_id,
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

Line 394: jtf_rs_group_usages u,

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,
397: jtf_rs_resource_extns res
398: WHERE m.group_id = g.group_id

Line 444: jtf_rs_group_usages u,

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,
447: jtf_rs_resource_extns res,
448: (

Line 676: jtf_rs_group_usages GRPUSG,

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
680:

Line 790: jtf_rs_group_usages GRPUSG,

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
793:
794: WHERE GRPMEM.resource_id = RES.resource_id

Line 4654: jtf_rs_group_usages GRPUSG,

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'
4658: AND HZPR_PART_CONT.SUBJECT_TABLE_NAME = 'HZ_PARTIES'