277: nvl(q.end_date, p_end_date),
278: nvl(rr.end_date_active, p_end_date), p_end_date) end_date
279: from cn_srp_plan_assigns_all spa,
280: cn_srp_quota_assigns_all sqa,
281: cn_quotas_all q,
282: cn_quota_rules_all qr,
283: cn_dim_hierarchies_all dh,
284: jtf_rs_salesreps jrs,
285: jtf_rs_group_members mem,
337: nvl(q.end_date, p_end_date),
338: nvl(rr.end_date_active, p_end_date), p_end_date) end_date
339: from cn_srp_plan_assigns_all spa,
340: cn_srp_quota_assigns_all sqa,
341: cn_quotas_all q,
342: cn_quota_rules_all qr,
343: jtf_rs_salesreps jrs,
344: jtf_rs_group_members mem,
345: jtf_rs_role_relations rr
553: rep.start_date,
554: rep.end_date)
555: loop
556: select nvl(indirect_credit, 'ALL') into l_indirect_credit
557: from cn_quotas_all
558: where quota_id = plan.quota_id;
559:
560: select manager_flag into l_manager_flag
561: from cn_roles