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_SFP_ROLE_UTIL_PVT dependencies on CN_RATE_TIERS

Line 111: -- CN_RATE_TIERS for the changes

107: -- If there is no rate schedule id for the given role quota
108: -- cate you can return success.
109: IF (l_rate_schedule_id > 0) THEN
110: -- Identify the rate_tier_id and sequence and compare against
111: -- CN_RATE_TIERS for the changes
112: FOR eachq IN role_quota_rate_cur LOOP
113: l_role_qc_cur.rate_tier_id := eachq.rate_tier_id;
114: l_role_qc_cur.rate_sequence := eachq.rate_sequence;
115:

Line 117: select count(*) INTO l_count_rate_tiers from cn_rate_tiers

113: l_role_qc_cur.rate_tier_id := eachq.rate_tier_id;
114: l_role_qc_cur.rate_sequence := eachq.rate_sequence;
115:
116: IF (l_role_qc_cur.rate_tier_id > 0) THEN
117: select count(*) INTO l_count_rate_tiers from cn_rate_tiers
118: where rate_tier_id = l_role_qc_cur.rate_tier_id
119: and rate_sequence = l_role_qc_cur.rate_sequence;
120:
121: -- If the tiers don't match to 1 no need to check further.