APPS.CN_RATE_TIERS_PKG dependencies on CN_RATE_TIERS_S

Line 32: CURSOR id IS SELECT CN_RATE_TIERS_S.NEXTVAL FROM DUAL;

28:
29: CURSOR C IS SELECT RATE_TIER_ID FROM CN_RATE_TIERS
30: WHERE RATE_TIER_ID = X_RATE_TIER_ID;
31:
32: CURSOR id IS SELECT CN_RATE_TIERS_S.NEXTVAL FROM DUAL;
33: BEGIN
34: IF (x_rate_tier_id IS NULL) THEN
35: OPEN id;
36: FETCH id INTO x_rate_tier_id;

Line 157: UPDATE cn_rate_tiers SET

153: x_rate_schedule_id => x_rate_schedule_id,
154: x_status_code => 'INCOMPLETE',
155: x_event => 'CHANGE_TIERS');
156:
157: UPDATE cn_rate_tiers SET
158: rate_schedule_id = x_rate_schedule_id,
159: commission_amount = x_commission_amount,
160: RATE_SEQUENCE = X_RATE_SEQUENCE,
161: last_update_date = X_Last_Update_Date,