DBA Data[Home] [Help]

APPS.CN_SRP_PER_QUOTA_RC_PKG dependencies on CN_QUOTAS_ALL

Line 202: ,cn_quotas_all q

198: ,Sysdate
199: ,fnd_global.login_id
200: ,pq.org_id
201: FROM cn_srp_period_quotas_all pq -- periods that rep/plan uses quota
202: ,cn_quotas_all q
203: WHERE pq.quota_id = x_quota_id
204: AND q.quota_id = pq.quota_id
205: AND q.quota_type_code IN ('FORMULA','EXTERNAL')
206:

Line 260: ,cn_quotas_all q

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
264: AND q.quota_type_code IN ('EXTERNAL','FORMULA')

Line 324: ,cn_quotas_all q

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
328: AND q.quota_id = x_quota_id

Line 387: ,cn_quotas_all q

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
391: AND q.quota_type_code IN ('EXTERNAL','FORMULA')