DBA Data[Home] [Help]

APPS.CN_MULTI_RATE_SCHEDULES_PKG dependencies on CN_RATE_TIERS

Line 210: -- delete records in cn_rate_tiers

206:
207: -- delete dimension assignments
208: DELETE FROM cn_rate_sch_dims WHERE rate_schedule_id = x_rate_schedule_id;
209:
210: -- delete records in cn_rate_tiers
211: DELETE FROM cn_rate_tiers WHERE rate_schedule_id = x_rate_schedule_id;
212:
213: delete from CN_RATE_SCHEDULES
214: where RATE_SCHEDULE_ID = X_RATE_SCHEDULE_ID;

Line 211: DELETE FROM cn_rate_tiers WHERE rate_schedule_id = x_rate_schedule_id;

207: -- delete dimension assignments
208: DELETE FROM cn_rate_sch_dims WHERE rate_schedule_id = x_rate_schedule_id;
209:
210: -- delete records in cn_rate_tiers
211: DELETE FROM cn_rate_tiers WHERE rate_schedule_id = x_rate_schedule_id;
212:
213: delete from CN_RATE_SCHEDULES
214: where RATE_SCHEDULE_ID = X_RATE_SCHEDULE_ID;
215: