APPS.JTF_RS_GROUP_USAGE_VUHK dependencies on CN_COMP_GROUPS

Line 55: FROM cn_comp_groups

51:
52: -- cursor to get the start_date and end_date of the new group
53: CURSOR dates IS
54: SELECT start_date_active, end_date_active, name
55: FROM cn_comp_groups
56: WHERE comp_group_id = p_group_id;
57:
58: -- cursor to find all srps in the new group
59: CURSOR srp_periods IS

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 300: FROM cn_comp_groups

296:
297: -- cursor to get the start_date and end_date of the new group
298: CURSOR dates IS
299: SELECT start_date_active, end_date_active, name
300: FROM cn_comp_groups
301: WHERE comp_group_id = p_group_id;
302:
303: -- cursor to find all srps in the new group
304: CURSOR srp_periods IS

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