APPS.CN_UPGRADE_UTL_PKG dependencies on CN_COMMISSION_HEADERS_ALL

Line 549: l_table_name VARCHAR2(30) := 'CN_COMMISSION_HEADERS_ALL';

545: p_batch_size IN NUMBER,
546: p_num_workers IN NUMBER,
547: p_worker_id IN NUMBER) IS
548:
549: l_table_name VARCHAR2(30) := 'CN_COMMISSION_HEADERS_ALL';
550: -- l_update_name VARCHAR2(30) := 'CNGSICNCMHUPD1212';
551: l_update_name VARCHAR2(30) := 'CNADSUPD12.0.9';
552:
553: l_product VARCHAR2(30) := 'CN' ;

Line 624: UPDATE /*+ ROWID (cha) */ CN_COMMISSION_HEADERS_ALL cha

620: WHILE (l_any_rows_to_process = TRUE) LOOP
621:
622: BEGIN
623:
624: UPDATE /*+ ROWID (cha) */ CN_COMMISSION_HEADERS_ALL cha
625: SET cha.adjust_status = NVL(cha.adjust_status,'NEW')
626: WHERE ROWID BETWEEN l_start_rowid AND l_end_rowid
627: AND cha.adjust_status IS NULL
628: AND EXISTS (SELECT NULL

Line 780: cn_commission_headers_all ch

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
784: AND cl.srp_plan_assign_id = srp.srp_plan_assign_id