801: p_role_id => c.role_id,
802: p_start_period_id => srp.period_id);
803: END LOOP;
804:
805: -- populate cn_srp_period_quotas
806: -- complicated logic so keep API call
807: cn_srp_period_quotas_pkg.insert_record
808: (
809: x_srp_plan_assign_id => c.srp_plan_assign_id
803: END LOOP;
804:
805: -- populate cn_srp_period_quotas
806: -- complicated logic so keep API call
807: cn_srp_period_quotas_pkg.insert_record
808: (
809: x_srp_plan_assign_id => c.srp_plan_assign_id
810: ,x_quota_id => NULL
811: ,x_start_period_id => srp.period_id
847: ,0 -- target amount
848: ,0 -- ytd
849: ,0 -- ptd
850: ,0 -- qtd
851: FROM cn_srp_period_quotas pq -- periods that rep/plan uses quota
852: ,cn_quota_rules qr
853: ,cn_quotas q
854: WHERE pq.srp_plan_assign_id = c.srp_plan_assign_id
855: AND pq.quota_id = qr.quota_id