APPS.CN_PERIODS_API dependencies on CN_SRP_PERIOD_QUOTAS

Line 801: -- populate cn_srp_period_quotas

797: p_role_id => c.role_id,
798: p_start_period_id => srp.period_id);
799: END LOOP;
800:
801: -- populate cn_srp_period_quotas
802: -- complicated logic so keep API call
803: cn_srp_period_quotas_pkg.insert_record
804: (
805: x_srp_plan_assign_id => c.srp_plan_assign_id

Line 803: cn_srp_period_quotas_pkg.insert_record

799: END LOOP;
800:
801: -- populate cn_srp_period_quotas
802: -- complicated logic so keep API call
803: cn_srp_period_quotas_pkg.insert_record
804: (
805: x_srp_plan_assign_id => c.srp_plan_assign_id
806: ,x_quota_id => NULL
807: ,x_start_period_id => srp.period_id

Line 847: FROM cn_srp_period_quotas pq -- periods that rep/plan uses quota

843: ,0 -- target amount
844: ,0 -- ytd
845: ,0 -- ptd
846: ,0 -- qtd
847: FROM cn_srp_period_quotas pq -- periods that rep/plan uses quota
848: ,cn_quota_rules qr
849: ,cn_quotas q
850: WHERE pq.srp_plan_assign_id = c.srp_plan_assign_id
851: AND pq.quota_id = qr.quota_id