DBA Data[Home] [Help]

APPS.CN_CALC_POPULATE_PVT dependencies on CN_SRP_COMP_GROUPS_V

Line 215: cn_srp_comp_groups_v scg

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
218: AND pb.start_date <= nvl(sct.end_date_active, pb.end_date)
219: AND sct.org_id = g_org_id