APPS.JTF_RS_GROUP_RELATE_VUHK dependencies on CN_SRP_COMP_GROUPS_V

Line 94: from cn_srp_comp_teams_v srt, cn_comp_teams ct, cn_srp_comp_groups_v cg

90: select distinct ct.name name,
91: ct.comp_team_id team_id,
92: greatest(p_start_date, cg.start_date_active, ct.start_date_active) start_date,
93: least(nvl(ct.end_date_active, l_max_date), nvl(cg.end_date_active, l_max_date), nvl(p_end_date, l_max_date)) end_date
94: from cn_srp_comp_teams_v srt, cn_comp_teams ct, cn_srp_comp_groups_v cg
95: where (p_salesrep_id IS NULL or srt.salesrep_id = p_salesrep_id)
96: and (p_salesrep_id IS NULL or cg.salesrep_id = p_salesrep_id)
97: and cg.comp_group_id = p_group_id
98: and srt.comp_team_id = ct.comp_team_id

Line 389: from cn_srp_comp_teams_v srt, cn_comp_teams ct, cn_srp_comp_groups_v cg

385: select distinct ct.name name,
386: ct.comp_team_id team_id,
387: greatest(p_start_date, cg.start_date_active, ct.start_date_active) start_date,
388: Least(nvl(ct.end_date_active, l_max_date), nvl(cg.end_date_active, l_max_date), nvl(p_end_date, l_max_date)) end_date
389: from cn_srp_comp_teams_v srt, cn_comp_teams ct, cn_srp_comp_groups_v cg
390: where (p_salesrep_id IS NULL or srt.salesrep_id = p_salesrep_id)
391: and (p_salesrep_id IS NULL or cg.salesrep_id = p_salesrep_id)
392: and cg.comp_group_id = p_group_id
393: and srt.comp_team_id = ct.comp_team_id

Line 613: from cn_srp_comp_teams_v srt, cn_comp_teams ct, cn_srp_comp_groups_v cg

609: select distinct ct.name name,
610: ct.comp_team_id team_id,
611: greatest(p_start_date, cg.start_date_active, ct.start_date_active) start_date,
612: least(nvl(ct.end_date_active, l_max_date), nvl(cg.end_date_active, l_max_date), nvl(p_end_date, l_max_date)) end_date
613: from cn_srp_comp_teams_v srt, cn_comp_teams ct, cn_srp_comp_groups_v cg
614: where srt.salesrep_id = p_salesrep_id
615: and cg.salesrep_id = p_salesrep_id
616: and cg.comp_group_id = p_group_id
617: and srt.comp_team_id = ct.comp_team_id

Line 821: from cn_srp_comp_teams_v srt, cn_comp_teams ct, cn_srp_comp_groups_v cg

817: select distinct ct.name name,
818: ct.comp_team_id team_id,
819: greatest(p_start_date, cg.start_date_active, ct.start_date_active) start_date,
820: Least(nvl(ct.end_date_active, l_max_date), nvl(cg.end_date_active, l_max_date), nvl(p_end_date, l_max_date) ) end_date
821: from cn_srp_comp_teams_v srt, cn_comp_teams ct, cn_srp_comp_groups_v cg
822: where srt.salesrep_id = p_salesrep_id
823: and cg.salesrep_id = p_salesrep_id
824: and cg.comp_group_id = p_group_id
825: and srt.comp_team_id = ct.comp_team_id