APPS.CN_MULTI_RATE_SCHEDULES_PUB dependencies on DUAL

Line 430: into l_name, l_comm_unit_code from dual;

426:
427: select decode(p_new_name, cn_api.g_miss_char, p_original_name, p_new_name),
428: decode(p_commission_unit_code, cn_api.g_miss_char,
429: l_original_comm_unit_code, p_commission_unit_code)
430: into l_name, l_comm_unit_code from dual;
431:
432: -- get ID's in the dims_tbl to pass on to private API
433: if p_dims_tbl.count > 0 then
434: for i in 1..p_dims_tbl.count loop

Line 1709: into l_name, l_description from dual;

1705: where rate_dimension_id = l_rate_dimension_id;
1706:
1707: select decode(p_new_name, cn_api.g_miss_char, p_original_name, p_new_name),
1708: decode(p_description, cn_api.g_miss_char, l_description, p_description)
1709: into l_name, l_description from dual;
1710:
1711: -- build l_tiers_tbl from the p_tiers_tbl
1712: if p_tiers_tbl.count > 0 then
1713: for i in p_tiers_tbl.first..p_tiers_tbl.last loop