Line 42: CURSOR id IS SELECT cn_rate_dim_tiers_s.NEXTVAL FROM dual;
38:
39: cursor C is select rate_dim_tier_id from CN_RATE_DIM_TIERS
40: where RATE_DIM_TIER_ID = x_rate_dim_tier_id;
41: 42: CURSOR id IS SELECT cn_rate_dim_tiers_s.NEXTVAL FROM dual; 43: BEGIN
44: IF (x_rate_dim_tier_id IS NULL) THEN
45: OPEN id;
46: FETCH id INTO x_rate_dim_tier_id;