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 2068: select cn_srp_rate_assigns_s.NEXTVAL into l_srp_rate_assign_id from dual;

2064: FETCH get_sqa_info into l_srp_plan_assign_id, l_quota_id;
2065: CLOSE get_sqa_info;
2066:
2067: -- we are assigning the rate for first time
2068: select cn_srp_rate_assigns_s.NEXTVAL into l_srp_rate_assign_id from dual;
2069:
2070: insert into cn_srp_rate_assigns
2071: (srp_plan_assign_id,
2072: srp_quota_assign_id,