APPS.CN_MULTI_RATE_SCHEDULES_PVT dependencies on DUAL

Line 101: FROM dual

97: x_usage_code OUT NOCOPY VARCHAR2)
98: IS
99: CURSOR usage_check IS
100: SELECT 'USED'
101: FROM dual
102: WHERE (exists (SELECT 1
103: FROM cn_rt_formula_asgns
104: WHERE rate_schedule_id = p_rate_schedule_id))
105: OR (exists (SELECT 1

Line 2077: select cn_srp_rate_assigns_s.NEXTVAL into l_srp_rate_assign_id from dual;

2073: FETCH get_sqa_info into l_srp_plan_assign_id, l_quota_id;
2074: CLOSE get_sqa_info;
2075:
2076: -- we are assigning the rate for first time
2077: select cn_srp_rate_assigns_s.NEXTVAL into l_srp_rate_assign_id from dual;
2078:
2079: insert into cn_srp_rate_assigns
2080: (srp_plan_assign_id,
2081: srp_quota_assign_id,