APPS.CN_SRP_QUOTA_RULES_PKG dependencies on CN_QUOTA_RULES_ALL

Line 34: FROM cn_quota_rules_all qr,

30: SELECT qr.target,
31: qr.payment_amount,
32: qr.performance_goal,
33: sqr.srp_quota_rule_id
34: FROM cn_quota_rules_all qr,
35: cn_srp_quota_rules_all sqr
36: WHERE qr.quota_rule_id = sqr.quota_rule_id
37: AND sqr.srp_quota_assign_id = x_srp_quota_assign_id
38: ;

Line 212: ,cn_quota_rules_all qr

208: ,Sysdate
209: ,fnd_global.login_id
210: ,sqa.org_id
211: FROM cn_srp_quota_assigns_all sqa
212: ,cn_quota_rules_all qr
213: WHERE sqa.srp_plan_assign_id = x_srp_plan_assign_id
214: AND sqa.quota_id = x_quota_id
215: AND qr.quota_id = sqa.quota_id
216: AND sqa.quota_type_code IN ('FORMULA','EXTERNAL')

Line 253: ,cn_quota_rules_all qr

249: ,Sysdate
250: ,fnd_global.login_id
251: ,sqa.org_id
252: FROM cn_srp_quota_assigns_all sqa
253: ,cn_quota_rules_all qr
254: WHERE sqa.srp_plan_assign_id = x_srp_plan_assign_id
255: AND sqa.quota_id = qr.quota_id
256: AND sqa.quota_type_code IN ('FORMULA','EXTERNAL')
257: ;

Line 296: ,cn_quota_rules_all qr

292: ,Sysdate
293: ,fnd_global.login_id
294: ,sqa.org_id
295: FROM cn_srp_quota_assigns_all sqa
296: ,cn_quota_rules_all qr
297: WHERE sqa.quota_id = x_quota_id
298: AND qr.quota_id = sqa.quota_id
299: AND qr.quota_rule_id = x_quota_rule_id
300: AND sqa.quota_type_code IN ('FORMULA','EXTERNAL')

Line 338: ,cn_quota_rules_all qr

334: ,Sysdate
335: ,fnd_global.login_id
336: ,sqa.org_id
337: FROM cn_srp_quota_assigns_all sqa
338: ,cn_quota_rules_all qr
339: WHERE sqa.quota_id = x_quota_id
340: AND qr.quota_id = sqa.quota_id
341: AND sqa.quota_type_code IN ('FORMULA', 'EXTERNAL')
342: ;