DBA Data[Home] [Help]

APPS.CN_SRP_PER_QUOTA_RC_PKG dependencies on CN_QUOTA_RULES_ALL

Line 265: ,cn_quota_rules_all qr

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
269: AND q.quota_id = qr.quota_id

Line 329: ,cn_quota_rules_all qr

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

Line 392: ,cn_quota_rules_all qr

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
396: AND qr.quota_id = q.quota_id