DBA Data[Home] [Help]

APPS.CN_UPGRADE_UTL_PKG dependencies on CN_COMMISSION_LINES_ALL

Line 779: FROM cn_commission_lines_all cl,

775:
776: UPDATE /*+ ROWID(srp) */ cn_srp_period_quotas_all srp
777: SET srp.transaction_amount_ptd = (
778: SELECT NVL(SUM(ch.transaction_amount), 0)
779: FROM cn_commission_lines_all cl,
780: cn_commission_headers_all ch
781: WHERE cl.credited_salesrep_id = srp.salesrep_id
782: AND cl.processed_period_id = srp.period_id
783: AND cl.quota_id = srp.quota_id