DBA Data[Home] [Help]

APPS.CN_SRP_PER_QUOTA_RC_PKG dependencies on CN_QUOTA_RULES_ALL

Line 259: ,cn_quota_rules_all qr

255: ,Sysdate
256: ,fnd_global.login_id
257: ,pq.org_id
258: FROM cn_srp_period_quotas_all pq -- periods that rep/plan uses quota
259: ,cn_quota_rules_all qr
260: ,cn_quotas_all q
261: WHERE pq.quota_id = q.quota_id
262: AND qr.quota_id = x_quota_id
263: AND q.quota_id = qr.quota_id

Line 323: ,cn_quota_rules_all qr

319: ,Sysdate
320: ,fnd_global.login_id
321: ,pq.org_id
322: FROM cn_srp_period_quotas_all pq -- periods that rep/plan uses quota
323: ,cn_quota_rules_all qr
324: ,cn_quotas_all q
325: WHERE pq.srp_plan_assign_id = x_srp_plan_assign_id
326: AND pq.quota_id = qr.quota_id
327: AND qr.quota_id = q.quota_id

Line 386: ,cn_quota_rules_all qr

382: ,Sysdate
383: ,fnd_global.login_id
384: ,pq.org_id
385: FROM cn_srp_period_quotas_all pq -- periods that rep/plan uses quota
386: ,cn_quota_rules_all qr
387: ,cn_quotas_all q
388: WHERE pq.srp_plan_assign_id = x_srp_plan_assign_id
389: AND pq.quota_id = qr.quota_id
390: AND qr.quota_id = q.quota_id