eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_SRP_RULE_UPLIFTS_PKG dependencies on CN_SRP_QUOTA_RULES_ALL

Line 63: ,cn_srp_quota_rules_all sqr

59: ,Sysdate
60: ,fnd_global.login_id
61: ,sqa.org_id
62: FROM cn_srp_quota_assigns_all sqa
63: ,cn_srp_quota_rules_all sqr
64: ,cn_quota_rule_uplifts_all qru
65: WHERE sqa.srp_plan_assign_id = p_srp_plan_assign_id
66: AND sqa.quota_id = p_quota_id
67: AND sqa.srp_quota_assign_id = sqr.srp_quota_assign_id

Line 102: ,cn_srp_quota_rules_all sqr

98: ,Sysdate
99: ,fnd_global.login_id
100: ,sqa.org_id
101: FROM cn_srp_quota_assigns_all sqa
102: ,cn_srp_quota_rules_all sqr
103: ,cn_quota_rule_uplifts_all qru
104: WHERE sqa.srp_plan_assign_id = p_srp_plan_assign_id
105: AND sqa.srp_quota_assign_id = sqr.srp_quota_assign_id
106: AND sqa.srp_plan_assign_id = sqr.srp_plan_assign_id

Line 140: FROM cn_srp_quota_rules_all sqr

136: ,fnd_global.user_id
137: ,Sysdate
138: ,fnd_global.login_id
139: ,sqr.org_id
140: FROM cn_srp_quota_rules_all sqr
141: ,cn_quota_rule_uplifts_all qru
142: WHERE sqr.quota_rule_id = p_quota_rule_id
143: AND qru.quota_rule_id = p_quota_rule_id
144: AND qru.quota_rule_id = sqr.quota_rule_id --bugfix 3633243

Line 176: FROM cn_srp_quota_rules_all sqr

172: ,fnd_global.user_id
173: ,Sysdate
174: ,fnd_global.login_id
175: ,sqr.org_id
176: FROM cn_srp_quota_rules_all sqr
177: ,cn_quota_rule_uplifts_all qru
178: WHERE sqr.quota_rule_id = qru.quota_rule_id
179: AND qru.quota_rule_id = p_quota_rule_id;
180:

Line 257: FROM cn_srp_quota_rules_all sqr

253: -- for each srp plan assign record
254: DELETE FROM cn_srp_rule_uplifts_all sru
255: WHERE sru.srp_quota_rule_id IN
256: ( SELECT sqr.srp_quota_rule_id
257: FROM cn_srp_quota_rules_all sqr
258: , cn_srp_quota_assigns sqa
259: WHERE sqa.srp_quota_assign_id = sqr.srp_quota_assign_id
260: AND sqa.srp_plan_assign_id = sqr.srp_plan_assign_id
261: AND sqa.srp_plan_assign_id = p_srp_plan_assign_id

Line 272: FROM cn_srp_quota_rules_all sqr

268: -- cn_srp_plan_assigns record has been deleted
269: DELETE FROM cn_srp_rule_uplifts_all sru
270: WHERE sru.srp_quota_rule_id IN
271: ( SELECT sqr.srp_quota_rule_id
272: FROM cn_srp_quota_rules_all sqr
273: WHERE sqr.srp_plan_assign_id = p_srp_plan_assign_id )
274: ;
275:
276: ELSIF ( p_srp_plan_assign_id IS NULL

Line 284: FROM cn_srp_quota_rules_all sqr, cn_quota_rules_all qr

280: -- cn_quota_rules record deleted
281: DELETE FROM cn_srp_rule_uplifts_all sru
282: WHERE sru.srp_quota_rule_id IN
283: (SELECT sqr.srp_quota_rule_id
284: FROM cn_srp_quota_rules_all sqr, cn_quota_rules_all qr
285: WHERE sqr.quota_rule_id = p_quota_rule_id
286: AND sqr.quota_rule_id = qr.quota_rule_id
287: AND sqr.revenue_class_id = qr.revenue_class_id);
288:

Line 302: cn_srp_quota_rules_all sqr

298: DELETE FROM cn_srp_rule_uplifts_all sru
299: WHERE sru.srp_quota_rule_id IN
300: (SELECT sqr.srp_quota_rule_id
301: FROM cn_quota_rules_all qr,
302: cn_srp_quota_rules_all sqr
303: WHERE sqr.quota_rule_id = qr.quota_rule_id
304: AND sqr.revenue_class_id = qr.revenue_class_id
305: AND quota_id = p_quota_id )
306: ;

Line 324: cn_srp_quota_rules_all r

320: , u.quota_factor = p_quota_factor
321: WHERE u.quota_rule_uplift_id = p_quota_rule_uplift_id
322: AND EXISTS (SELECT 'quota rule uplift belongs to a uncustomized quota'
323: FROM cn_srp_quota_assigns_all q,
324: cn_srp_quota_rules_all r
325: WHERE q.srp_quota_assign_id = r.srp_quota_assign_id
326: AND r.srp_quota_rule_id = u.srp_quota_rule_id
327: AND q.customized_flag = 'N')
328: ;