APPS.PV_TERR_ASSIGN_PUB dependencies on JTF_RS_GROUPS_B

Line 334: FROM jtf_rs_groups_b g,

330: ( SELECT distinct m.resource_id resource_id,
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,

Line 393: jtf_rs_groups_b g,

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,
397: jtf_rs_resource_extns res

Line 443: jtf_rs_groups_b g,

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

Line 671: /* PINAGARA: Introduced jtf_rs_groups_b table as bug fix for 4869726 */

667: IS
668:
669: l_res_is_vendor_CM VARCHAR2(1) ;
670:
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,

Line 679: jtf_rs_groups_b b

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:
681: WHERE RES.resource_id = cv_resource_id
682: AND RES.category = 'EMPLOYEE'
683: AND sysdate between nvl(RES.start_date_active,sysdate) and

Line 789: jtf_rs_groups_b GROUPB,

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