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_QUOTA_RULES_ALL

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 301: FROM cn_quota_rules_all qr,

297: ELSIF ( p_quota_id IS NOT NULL ) THEN
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 )