eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_CALC_POPULATE_PVT dependencies on CN_SRP_COMP_TEAMS_V

Line 213: FROM cn_srp_comp_teams_v sct,

209: sct.comp_team_id,
210: scg.comp_group_id,
211: greatest(pb.start_date, sct.start_date_active, scg.start_date_active) start_date,
212: least(pb.end_date, nvl(sct.end_date_active, pb.end_date), nvl(scg.end_date_active, pb.end_date)) end_date
213: FROM cn_srp_comp_teams_v sct,
214: cn_process_batches_all pb,
215: cn_srp_comp_groups_v scg
216: WHERE pb.physical_batch_id = p_physical_batch_id
217: AND pb.salesrep_id = sct.salesrep_id

Line 230: FROM cn_srp_comp_teams_v sct

226: CURSOR other_mbrs(p_comp_team_id NUMBER, p_salesrep_id NUMBER, p_start_date DATE, p_end_date DATE) IS
227: SELECT sct.salesrep_id,
228: greatest(p_start_date, sct.start_date_active) start_date,
229: least(p_end_date, nvl(sct.end_date_active, p_end_date)) end_date
230: FROM cn_srp_comp_teams_v sct
231: WHERE sct.comp_team_id = p_comp_team_id
232: AND sct.salesrep_id <> p_salesrep_id
233: AND sct.org_id = g_org_id
234: AND p_start_date <= nvl(sct.end_date_active, p_end_date)