DBA Data[Home] [Help]

APPS.CN_PERIODS_API dependencies on CN_SRP_PERIOD_QUOTAS

Line 805: -- populate cn_srp_period_quotas

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

Line 807: cn_srp_period_quotas_pkg.insert_record

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

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

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