APPS.CN_FORMULA_COMMON_PKG dependencies on CN_SRP_INTEL_PERIODS_ALL

Line 1727: cn_srp_intel_periods_all prd

1723: prd.process_all_flag,
1724: decode(prd.period_id, batch.period_id, batch.start_date, prd.start_date) start_date
1725: FROM cn_process_batches_all batch,
1726: cn_srp_plan_assigns_all spa,
1727: cn_srp_intel_periods_all prd
1728: WHERE batch.physical_batch_id = p_physical_batch_id
1729: AND prd.salesrep_id = batch.salesrep_id
1730: AND prd.period_id BETWEEN batch.period_id AND batch.end_period_id
1731: AND prd.org_id = batch.org_id

Line 2134: update cn_srp_intel_periods_all a

2130: AND event.status = 'INCOMPLETE') ;
2131: commit;
2132:
2133: -- reset process_all_flag = 'N' since calculation completed sucessfully
2134: update cn_srp_intel_periods_all a
2135: set a.process_all_flag = 'N'
2136: where a.org_id = l_org_id
2137: and a.salesrep_id in (select salesrep_id from cn_process_batches_all
2138: where physical_batch_id = p_physical_batch_id)

Line 2698: UPDATE cn_srp_intel_periods_all

2694:
2695: -- since 'POP' event only affect a particular quota, we shouldn't mark the whole period
2696: -- will be considered in calculate_batch
2697:
2698: UPDATE cn_srp_intel_periods_all
2699: SET process_all_flag = 'Y'
2700: WHERE org_id = l_org_id
2701: AND ( salesrep_id, period_id ) IN
2702: ( SELECT DISTINCT batch.salesrep_id, Log.period_id

Line 3153: update cn_srp_intel_periods_all a

3149: where physical_batch_id = p_batch_id
3150: and rownum = 1;
3151:
3152: -- mark process_all_flag = 'Y'
3153: update cn_srp_intel_periods_all a
3154: set a.process_all_flag = 'Y'
3155: where a.org_id = l_org_id
3156: and a.salesrep_id in (select salesrep_id from cn_process_batches_all
3157: where physical_batch_id = p_batch_id)