827:
828: CURSOR get_quotas(p_payrun cn_payruns.payrun_id%TYPE) IS
829: select distinct w.quota_id,q.name
830: from cn_payment_worksheets w, 831: cn_quotas q,cn_salesreps cns 832: where payrun_id=p_payrun
833: and w.quota_id is not null
834: and w.quota_id=q.quota_id
835: and w.salesrep_id=cns.salesrep_id