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_QUOTA_ASSIGNS_PKG dependencies on CN_SRP_QUOTA_RULES_ALL

Line 115: , cn_srp_quota_rules_all csqr

111: (
112: SELECT 'X'
113: FROM cn_srp_quota_assigns_all csqa
114: , cn_quota_rules_all cqr
115: , cn_srp_quota_rules_all csqr
116: , cn_quota_rule_uplifts_all cqru
117: , cn_srp_rule_uplifts_all csru
118: WHERE csqa.srp_quota_assign_id = x_srp_quota_assign_id
119: AND cqr.quota_id = x_quota_id

Line 575: cn_srp_quota_rules_all sqr

571: qr.payment_amount,
572: qr.performance_goal,
573: sqr.srp_quota_rule_id
574: FROM cn_quota_rules_all qr,
575: cn_srp_quota_rules_all sqr
576: WHERE qr.quota_rule_id = sqr.quota_rule_id
577: AND sqr.srp_quota_assign_id = x_srp_quota_assign_id
578: ;
579:

Line 664: UPDATE cn_srp_quota_rules_all

660: LOOP
661: FETCH sqr_curs INTO l_recinfo;
662: EXIT WHEN sqr_curs%notfound;
663:
664: UPDATE cn_srp_quota_rules_all
665: SET target = l_recinfo.target,
666: payment_amount = l_recinfo.payment_amount,
667: performance_goal = l_recinfo.performance_goal
668: WHERE srp_quota_rule_id = l_recinfo.srp_quota_rule_id