192: ,0 -- ytd
193: ,0 -- ptd
194: ,0 -- qtd
195: ,Sysdate
196: ,fnd_global.user_id
197: ,fnd_global.user_id
198: ,Sysdate
199: ,fnd_global.login_id
200: ,pq.org_id
193: ,0 -- ptd
194: ,0 -- qtd
195: ,Sysdate
196: ,fnd_global.user_id
197: ,fnd_global.user_id
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
195: ,Sysdate
196: ,fnd_global.user_id
197: ,fnd_global.user_id
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
249: ,0 -- ytd
250: ,0 -- ptd
251: ,0 -- qtd
252: ,Sysdate
253: ,fnd_global.user_id
254: ,fnd_global.user_id
255: ,Sysdate
256: ,fnd_global.login_id
257: ,pq.org_id
250: ,0 -- ptd
251: ,0 -- qtd
252: ,Sysdate
253: ,fnd_global.user_id
254: ,fnd_global.user_id
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
252: ,Sysdate
253: ,fnd_global.user_id
254: ,fnd_global.user_id
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
313: ,0 -- ytd
314: ,0 -- ptd
315: ,0 -- qtd
316: ,Sysdate
317: ,fnd_global.user_id
318: ,fnd_global.user_id
319: ,Sysdate
320: ,fnd_global.login_id
321: ,pq.org_id
314: ,0 -- ptd
315: ,0 -- qtd
316: ,Sysdate
317: ,fnd_global.user_id
318: ,fnd_global.user_id
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
316: ,Sysdate
317: ,fnd_global.user_id
318: ,fnd_global.user_id
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
376: ,0 -- ytd
377: ,0 -- ptd
378: ,0 -- qtd
379: ,Sysdate
380: ,fnd_global.user_id
381: ,fnd_global.user_id
382: ,Sysdate
383: ,fnd_global.login_id
384: ,pq.org_id
377: ,0 -- ptd
378: ,0 -- qtd
379: ,Sysdate
380: ,fnd_global.user_id
381: ,fnd_global.user_id
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
379: ,Sysdate
380: ,fnd_global.user_id
381: ,fnd_global.user_id
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