DBA Data[Home] [Help]

APPS.CN_PAYRUN_PVT dependencies on CN_QUOTAS

Line 831: cn_quotas q,cn_salesreps cns

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