APPS.JTF_RS_TEAMS_PVT dependencies on JTF_RS_ROLE_RELATIONS

Line 677: FROM jtf_rs_role_relations

673: l_team_id IN NUMBER )
674: IS
675: SELECT min(start_date_active),
676: max(end_date_active)
677: FROM jtf_rs_role_relations
678: WHERE role_resource_type = 'RS_TEAM'
679: AND role_resource_id = l_team_id
680: AND nvl(delete_flag, 'N') <> 'Y'
681: AND end_date_active is not null;

Line 688: FROM jtf_rs_role_relations

684: CURSOR c_related_role_dates_sec(
685: l_team_id IN NUMBER )
686: IS
687: SELECT min(start_date_active)
688: FROM jtf_rs_role_relations
689: WHERE role_resource_type = 'RS_TEAM'
690: AND role_resource_id = l_team_id
691: AND nvl(delete_flag, 'N') <> 'Y'
692: AND end_date_active is null;

Line 701: jtf_rs_role_relations jrrr

697: IS
698: SELECT min(jrrr.start_date_active),
699: max(jrrr.end_date_active)
700: FROM jtf_rs_team_members jrgm,
701: jtf_rs_role_relations jrrr
702: WHERE jrgm.team_member_id = jrrr.role_resource_id
703: AND jrrr.role_resource_type = 'RS_TEAM_MEMBER'
704: AND nvl(jrrr.delete_flag, 'N') <> 'Y'
705: AND nvl(jrgm.delete_flag, 'N') <> 'Y'

Line 715: jtf_rs_role_relations jrrr

711: l_team_id IN NUMBER )
712: IS
713: SELECT min(jrrr.start_date_active)
714: FROM jtf_rs_team_members jrgm,
715: jtf_rs_role_relations jrrr
716: WHERE jrgm.team_member_id = jrrr.role_resource_id
717: AND jrrr.role_resource_type = 'RS_TEAM_MEMBER'
718: AND nvl(jrrr.delete_flag, 'N') <> 'Y'
719: AND nvl(jrgm.delete_flag, 'N') <> 'Y'

Line 734: jtf_rs_role_relations RR1,

730: jtf_rs_team_members TM1,
731: jtf_rs_team_members TM2,
732: jtf_rs_team_usages TU1,
733: jtf_rs_team_usages TU2,
734: jtf_rs_role_relations RR1,
735: jtf_rs_role_relations RR2
736: WHERE T1.team_id = TM1.team_id
737: AND T2.team_id = TM2.team_id
738: AND nvl(TM1.delete_flag, 'N') <> 'Y'

Line 735: jtf_rs_role_relations RR2

731: jtf_rs_team_members TM2,
732: jtf_rs_team_usages TU1,
733: jtf_rs_team_usages TU2,
734: jtf_rs_role_relations RR1,
735: jtf_rs_role_relations RR2
736: WHERE T1.team_id = TM1.team_id
737: AND T2.team_id = TM2.team_id
738: AND nvl(TM1.delete_flag, 'N') <> 'Y'
739: AND nvl(TM2.delete_flag, 'N') <> 'Y'