DBA Data[Home] [Help]

APPS.CN_SRP_PER_QUOTA_RC_PKG dependencies on CN_SRP_PERIOD_QUOTAS_ALL

Line 207: FROM cn_srp_period_quotas_all pq -- periods that rep/plan uses quota

203: ,fnd_global.user_id
204: ,Sysdate
205: ,fnd_global.login_id
206: ,pq.org_id
207: FROM cn_srp_period_quotas_all pq -- periods that rep/plan uses quota
208: ,cn_quotas_all q
209: WHERE pq.quota_id = x_quota_id
210: AND q.quota_id = pq.quota_id
211: AND q.quota_type_code IN ('FORMULA','EXTERNAL')

Line 264: FROM cn_srp_period_quotas_all pq -- periods that rep/plan uses quota

260: ,fnd_global.user_id
261: ,Sysdate
262: ,fnd_global.login_id
263: ,pq.org_id
264: FROM cn_srp_period_quotas_all pq -- periods that rep/plan uses quota
265: ,cn_quota_rules_all qr
266: ,cn_quotas_all q
267: WHERE pq.quota_id = q.quota_id
268: AND qr.quota_id = x_quota_id

Line 328: FROM cn_srp_period_quotas_all pq -- periods that rep/plan uses quota

324: ,fnd_global.user_id
325: ,Sysdate
326: ,fnd_global.login_id
327: ,pq.org_id
328: FROM cn_srp_period_quotas_all pq -- periods that rep/plan uses quota
329: ,cn_quota_rules_all qr
330: ,cn_quotas_all q
331: WHERE pq.srp_plan_assign_id = x_srp_plan_assign_id
332: AND pq.quota_id = qr.quota_id

Line 391: FROM cn_srp_period_quotas_all pq -- periods that rep/plan uses quota

387: ,fnd_global.user_id
388: ,Sysdate
389: ,fnd_global.login_id
390: ,pq.org_id
391: FROM cn_srp_period_quotas_all pq -- periods that rep/plan uses quota
392: ,cn_quota_rules_all qr
393: ,cn_quotas_all q
394: WHERE pq.srp_plan_assign_id = x_srp_plan_assign_id
395: AND pq.quota_id = qr.quota_id