DBA Data[Home] [Help]

APPS.CN_GET_COMM_SUMM_DATA_PVT dependencies on CN_SRP_PERIOD_QUOTAS

Line 425: FROM cn_srp_period_quotas cspq,

421: nvl(sum(cspq.perf_achieved_ptd),0) credit,
422: nvl(sum(cspq.commission_payed_ptd),0) earnings,
423: nvl(sum(cspq.target_amount),0) target,
424: nvl(sum(cspq.itd_target),0) itd_target
425: FROM cn_srp_period_quotas cspq,
426: cn_quotas_all quota,
427: cn_period_statuses ps,
428: cn_repositories r,
429: cn_period_statuses ps2

Line 488: FROM cn_srp_period_quotas cspq,

484:
485: CURSOR rolling_quota_cur IS
486: SELECT nvl(cspq.rollover,0),
487: nvl(cspq.total_rollover,0)
488: FROM cn_srp_period_quotas cspq,
489: cn_quotas quota
490: WHERE cspq.period_id = p_period_id
491: AND cspq.srp_plan_assign_id = p_srp_plan_assign_id
492: AND cspq.quota_id = quota.quota_id