APPS.CN_FORMULA_COMMON_PKG dependencies on CN_SRP_INTEL_PERIODS_ALL

Line 1728: cn_srp_intel_periods_all prd

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

Line 2150: update cn_srp_intel_periods_all a

2146: AND event.status = 'INCOMPLETE') ;
2147: commit;
2148:
2149: -- reset process_all_flag = 'N' since calculation completed sucessfully
2150: update cn_srp_intel_periods_all a
2151: set a.process_all_flag = 'N'
2152: where a.org_id = l_org_id
2153: and a.salesrep_id in (select salesrep_id from cn_process_batches_all
2154: where physical_batch_id = p_physical_batch_id)

Line 2714: UPDATE cn_srp_intel_periods_all

2710:
2711: -- since 'POP' event only affect a particular quota, we shouldn't mark the whole period
2712: -- will be considered in calculate_batch
2713:
2714: UPDATE cn_srp_intel_periods_all
2715: SET process_all_flag = 'Y'
2716: WHERE org_id = l_org_id
2717: AND ( salesrep_id, period_id ) IN
2718: ( SELECT DISTINCT batch.salesrep_id, Log.period_id

Line 3169: update cn_srp_intel_periods_all a

3165: where physical_batch_id = p_batch_id
3166: and rownum = 1;
3167:
3168: -- mark process_all_flag = 'Y'
3169: update cn_srp_intel_periods_all a
3170: set a.process_all_flag = 'Y'
3171: where a.org_id = l_org_id
3172: and a.salesrep_id in (select salesrep_id from cn_process_batches_all
3173: where physical_batch_id = p_batch_id)