APPS.CN_RT_QUOTA_ASGN_PVT dependencies on CN_RATE_SCHEDULES

Line 22: cn_rate_schedules_all rs,

18: rf.rate_schedule_id,
19: rs.NAME,
20: fml.NAME calc_formula_name
21: FROM cn_rt_formula_asgns rf,
22: cn_rate_schedules_all rs,
23: cn_calc_formulas fml
24: WHERE fml.calc_formula_id = p_calc_formula_id AND rf.rate_schedule_id = rs.rate_schedule_id AND fml.calc_formula_id = rf.calc_formula_id;
25:
26: l_rec rt_quota_asgn_rec_type;

Line 165: FROM CN_RATE_SCHEDULES

161: x_msg_data := fnd_api.g_null_char;
162: x_msg_count := fnd_api.g_null_num;
163: -- Getting the rate table name
164: SELECT NAME INTO l_temp_old
165: FROM CN_RATE_SCHEDULES
166: WHERE RATE_SCHEDULE_ID = p_rt_quota_asgn.rate_schedule_id
167: AND ORG_ID = p_rt_quota_asgn.org_id;
168:
169: IF (p_operation = 'create') THEN

Line 187: FROM CN_RATE_SCHEDULES

183: l_temp_new := 'CN_QUOTAS';
184: END IF;
185: IF (p_operation = 'update') THEN
186: SELECT NAME INTO l_old_rt_name
187: FROM CN_RATE_SCHEDULES
188: WHERE RATE_SCHEDULE_ID = p_old_rt_quota_asgn.rate_schedule_id
189: AND ORG_ID = p_old_rt_quota_asgn.org_id;
190:
191: fnd_message.set_name('CN','CNR12_NOTE_PE_RT_ASGN_UPD');

Line 1186: l_rate_dim CN_RATE_SCHEDULES.NUMBER_DIM%TYPE;

1182: l_name VARCHAR2 (1000);
1183: l_loading_status VARCHAR2 (240);
1184: l_formula_type CN_QUOTAS.QUOTA_TYPE_CODE%TYPE ;
1185: l_formula_dim CN_CALC_FORMULAS.NUMBER_DIM%TYPE;
1186: l_rate_dim CN_RATE_SCHEDULES.NUMBER_DIM%TYPE;
1187: BEGIN
1188: -- Standard Start of API savepoint
1189: SAVEPOINT check_rt_quota_asgn;
1190:

Line 1228: FROM cn_rate_schedules

1224: ELSE
1225: BEGIN
1226: SELECT NAME
1227: INTO l_name
1228: FROM cn_rate_schedules
1229: WHERE rate_schedule_id = p_rt_quota_asgn.rate_schedule_id;
1230: EXCEPTION
1231: WHEN NO_DATA_FOUND
1232: THEN

Line 1367: SELECT NUMBER_DIM INTO l_rate_dim FROM CN_RATE_SCHEDULES

1363: -- CHECK THAT NUMBER OF FORMULA DIMS = NUMBER OF RATE DIMS
1364: IF l_formula_type = 'FORMULA' THEN
1365: SELECT NUMBER_DIM INTO l_formula_dim FROM CN_CALC_FORMULAS
1366: WHERE calc_formula_id = p_rt_quota_asgn.calc_formula_id;
1367: SELECT NUMBER_DIM INTO l_rate_dim FROM CN_RATE_SCHEDULES
1368: WHERE rate_schedule_id = p_rt_quota_asgn.rate_schedule_id;
1369: IF l_formula_dim <> l_rate_dim THEN
1370: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1371: THEN