APPS.JTF_RS_GROUP_USAGE_VUHK dependencies on CN_SRP_COMP_TEAMS_V

Line 89: from cn_srp_comp_teams_v srt, cn_comp_teams ct, cn_comp_groups cg

85: select ct.name name,
86: ct.comp_team_id team_id,
87: greatest(cg.start_date_active, ct.start_date_active) start_date,
88: Least(nvl(ct.end_date_active, l_max_date), nvl(cg.end_date_active, l_max_date)) end_date
89: from cn_srp_comp_teams_v srt, cn_comp_teams ct, cn_comp_groups cg
90: where srt.salesrep_id = p_salesrep_id
91: and srt.comp_team_id = ct.comp_team_id
92: and cg.comp_group_id = p_group_id
93: and (cg.start_date_active <= ct.start_date_active

Line 334: from cn_srp_comp_teams_v srt, cn_comp_teams ct, cn_comp_groups cg

330: select ct.name name,
331: ct.comp_team_id team_id,
332: greatest(cg.start_date_active, ct.start_date_active) start_date,
333: Least(nvl(ct.end_date_active, l_max_date), nvl(cg.end_date_active, l_max_date)) end_date
334: from cn_srp_comp_teams_v srt, cn_comp_teams ct, cn_comp_groups cg
335: where srt.salesrep_id = p_salesrep_id
336: and srt.comp_team_id = ct.comp_team_id
337: and cg.comp_group_id = p_group_id
338: and (cg.start_date_active <= ct.start_date_active