DBA Data[Home] [Help]

APPS.JTF_RS_GROUPS_PVT dependencies on JTF_RS_TEAM_MEMBERS

Line 903: FROM jtf_rs_team_members jrtm,

899: l_group_id IN NUMBER )
900: IS
901: SELECT min(jrrr.start_date_active),
902: max(jrrr.end_date_active)
903: FROM jtf_rs_team_members jrtm,
904: jtf_rs_role_relations jrrr
905: WHERE jrtm.team_member_id = jrrr.role_resource_id
906: AND jrrr.role_resource_type = 'RS_TEAM_MEMBER'
907: AND nvl(jrrr.delete_flag, 'N') <> 'Y'

Line 918: FROM jtf_rs_team_members jrtm,

914: CURSOR c_team_mbr_role_dates_sec(
915: l_group_id IN NUMBER )
916: IS
917: SELECT min(jrrr.start_date_active)
918: FROM jtf_rs_team_members jrtm,
919: jtf_rs_role_relations jrrr
920: WHERE jrtm.team_member_id = jrrr.role_resource_id
921: AND jrrr.role_resource_type = 'RS_TEAM_MEMBER'
922: AND nvl(jrrr.delete_flag, 'N') <> 'Y'