DBA Data[Home] [Help]

APPS.CN_SRP_PER_QUOTA_RC_PKG dependencies on CN_QUOTAS_ALL

Line 208: ,cn_quotas_all q

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')
212:

Line 266: ,cn_quotas_all q

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
269: AND q.quota_id = qr.quota_id
270: AND q.quota_type_code IN ('EXTERNAL','FORMULA')

Line 330: ,cn_quotas_all q

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
333: AND qr.quota_id = q.quota_id
334: AND q.quota_id = x_quota_id

Line 393: ,cn_quotas_all q

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
396: AND qr.quota_id = q.quota_id
397: AND q.quota_type_code IN ('EXTERNAL','FORMULA')