APPS.JTF_TTY_NA_TERRGP dependencies on JTF_RS_GROUPS_DENORM

Line 455: (SELECT parent_group_id FROM jtf_rs_groups_denorm

451: SELECT 'SAME'
452: INTO x_hierarchy_status
453: FROM dual
454: WHERE (p_group_id1 IN
455: (SELECT parent_group_id FROM jtf_rs_groups_denorm
456: WHERE group_id = p_group_id2)
457: OR p_group_id1 IN
458: (SELECT group_id FROM jtf_rs_groups_denorm
459: WHERE parent_group_id = p_group_id2))

Line 458: (SELECT group_id FROM jtf_rs_groups_denorm

454: WHERE (p_group_id1 IN
455: (SELECT parent_group_id FROM jtf_rs_groups_denorm
456: WHERE group_id = p_group_id2)
457: OR p_group_id1 IN
458: (SELECT group_id FROM jtf_rs_groups_denorm
459: WHERE parent_group_id = p_group_id2))
460: AND ROWNUM < 2;
461: EXCEPTION
462: WHEN NO_DATA_FOUND THEN

Line 525: jtf_rs_groups_denorm gd

521: tgo.rsc_group_id parentgrpid
522: FROM JTF_TTY_NAMED_ACCT_RSC NAR,
523: JTF_TTY_TERR_GRP_ACCTS TGA,
524: jtf_tty_terr_grp_owners tgo,
525: jtf_rs_groups_denorm gd
526: WHERE NAR.terr_group_account_id = TGA.terr_group_account_id
527: AND TGA.TERR_GROUP_ID = p_terr_gp_id
528: AND NAR.rsc_resource_type = 'RS_EMPLOYEE'
529: AND gd.group_id = NAR.RSC_GROUP_ID

Line 553: jtf_rs_groups_denorm gd

549: AND NOT EXISTS
550: (
551: SELECT NULL
552: FROM jtf_tty_terr_grp_owners tgo,
553: jtf_rs_groups_denorm gd
554: WHERE gd.group_id = NAR.RSC_GROUP_ID
555: AND gd.parent_group_id = tgo.rsc_group_id
556: AND tgo.rsc_resource_type = 'RS_EMPLOYEE'
557: AND tgo.TERR_GROUP_ID = p_terr_gp_id

Line 649: FROM jtf_rs_groups_denorm

645: -- in 11.5.6 env there is no active_flag column
646: -- Fix for bug 4313953
647:
648: SELECT 'PARENT_CHILD' INTO result
649: FROM jtf_rs_groups_denorm
650: WHERE SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE)
651: AND
652: ( group_id = DelCandidateGrp(idx)
653: AND parent_group_id = NewCandidateGrp(indx)

Line 702: jtf_rs_groups_denorm grpdn

698: FROM jtf_tty_named_acct_rsc narsc,
699: jtf_tty_terr_grp_accts tga,
700: jtf_rs_role_relations rlt ,
701: jtf_rs_group_members grpmem ,
702: jtf_rs_groups_denorm grpdn
703: WHERE narsc.terr_group_account_id = tga.terr_group_account_id
704: AND tga.terr_group_id = DelCandidateGrp(idx)
705: AND narsc.resource_id = grpmem.resource_id
706: AND narsc.rsc_group_id = grpmem.group_id

Line 716: FROM jtf_rs_groups_denorm grpdn1

712: AND grpmem.group_id = grpdn.group_id
713: AND SYSDATE BETWEEN grpdn.start_date_active AND NVL(grpdn.end_date_active, SYSDATE+1)
714: AND grpdn.parent_group_id = NewCandidateGrp(indx)
715: AND EXISTS ( SELECT 'Y'
716: FROM jtf_rs_groups_denorm grpdn1
717: WHERE narsc.rsc_group_id = grpdn1.group_id
718: AND grpdn1.parent_group_id = DelCandidateGrp(idx)
719: )
720: AND ROWNUM < 2;

Line 866: jtf_rs_groups_denorm grpdn

862: IN ( SELECT terr_group_account_id
863: FROM jtf_tty_terr_grp_accts,
864: jtf_rs_role_relations rlt ,
865: jtf_rs_group_members grpmem ,
866: jtf_rs_groups_denorm grpdn
867: WHERE terr_group_id = p_terr_gp_id
868: AND grpmem.resource_id = narsc.resource_id
869: AND grpmem.group_id = narsc.rsc_group_id
870: AND grpmem.group_member_id = rlt.role_resource_id

Line 876: from jtf_rs_groups_denorm grpdn1

872: AND grpmem.group_id = grpdn.group_id
873: AND grpdn.parent_group_id = rplownerfromgrp(idx)
874: AND NOT EXISTS
875: ( select 'Y'
876: from jtf_rs_groups_denorm grpdn1
877: where grpmem.group_id = grpdn1.group_id
878: and grpdn1.parent_group_id = rplownertogrp(idx)
879: and sysdate between grpdn1.start_date_active
880: and nvl(grpdn1.end_date_active,sysdate+1)

Line 1065: FROM jtf_rs_groups_denorm gd

1061: )
1062: AND EXISTS
1063: (
1064: SELECT NULL
1065: FROM jtf_rs_groups_denorm gd
1066: WHERE owner.rsc_group_id = gd.parent_group_id
1067: AND gd.group_id = tgaNoParent.currentgrpid
1068: )
1069: );

Line 2420: FROM jtf_rs_groups_denorm

2416:
2417: CURSOR child_groups_c
2418: IS
2419: SELECT group_id
2420: FROM jtf_rs_groups_denorm
2421: WHERE PARENT_GROUP_ID = managed_group_id;
2422:
2423: CURSOR directs_c
2424: IS