198: ,0 -- ytd
199: ,0 -- ptd
200: ,0 -- qtd
201: ,Sysdate
202: ,fnd_global.user_id
203: ,fnd_global.user_id
204: ,Sysdate
205: ,fnd_global.login_id
206: ,pq.org_id
199: ,0 -- ptd
200: ,0 -- qtd
201: ,Sysdate
202: ,fnd_global.user_id
203: ,fnd_global.user_id
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
201: ,Sysdate
202: ,fnd_global.user_id
203: ,fnd_global.user_id
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
255: ,0 -- ytd
256: ,0 -- ptd
257: ,0 -- qtd
258: ,Sysdate
259: ,fnd_global.user_id
260: ,fnd_global.user_id
261: ,Sysdate
262: ,fnd_global.login_id
263: ,pq.org_id
256: ,0 -- ptd
257: ,0 -- qtd
258: ,Sysdate
259: ,fnd_global.user_id
260: ,fnd_global.user_id
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
258: ,Sysdate
259: ,fnd_global.user_id
260: ,fnd_global.user_id
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
319: ,0 -- ytd
320: ,0 -- ptd
321: ,0 -- qtd
322: ,Sysdate
323: ,fnd_global.user_id
324: ,fnd_global.user_id
325: ,Sysdate
326: ,fnd_global.login_id
327: ,pq.org_id
320: ,0 -- ptd
321: ,0 -- qtd
322: ,Sysdate
323: ,fnd_global.user_id
324: ,fnd_global.user_id
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
322: ,Sysdate
323: ,fnd_global.user_id
324: ,fnd_global.user_id
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
382: ,0 -- ytd
383: ,0 -- ptd
384: ,0 -- qtd
385: ,Sysdate
386: ,fnd_global.user_id
387: ,fnd_global.user_id
388: ,Sysdate
389: ,fnd_global.login_id
390: ,pq.org_id
383: ,0 -- ptd
384: ,0 -- qtd
385: ,Sysdate
386: ,fnd_global.user_id
387: ,fnd_global.user_id
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
385: ,Sysdate
386: ,fnd_global.user_id
387: ,fnd_global.user_id
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