APPS.CN_UPGRADE_UTL_PKG dependencies on CN_SRP_PERIOD_QUOTAS_ALL

Line 676: l_table_name VARCHAR2(30) := 'CN_SRP_PERIOD_QUOTAS_ALL';

672: p_batch_size IN NUMBER,
673: p_num_workers IN NUMBER,
674: p_worker_id IN NUMBER) IS
675:
676: l_table_name VARCHAR2(30) := 'CN_SRP_PERIOD_QUOTAS_ALL';
677: l_update_name VARCHAR2(30) := 'CNSRPTXN';
678:
679: l_product VARCHAR2(30) := 'CN' ;
680: l_status VARCHAR2(30);

Line 707: fnd_file.put_line(FND_FILE.LOG, 'Updating CN_SRP_PERIOD_QUOTAS_ALL to populate transaction_amount_ptd ');

703: l_batch_size := p_batch_size;
704: l_num_workers := p_num_workers;
705: l_worker_id := p_worker_id;
706:
707: fnd_file.put_line(FND_FILE.LOG, 'Updating CN_SRP_PERIOD_QUOTAS_ALL to populate transaction_amount_ptd ');
708: -- get schema name of the table for ROWID range processing
709: l_retstatus := fnd_installation.get_app_info(l_product, l_status, l_industry, l_table_owner);
710:
711: if ((l_retstatus = FALSE) OR (l_table_owner is null))

Line 776: UPDATE /*+ ROWID(srp) */ cn_srp_period_quotas_all srp

772: WHILE (l_any_rows_to_process = TRUE) LOOP
773:
774: BEGIN
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