APPS.CN_MULTI_RATE_SCHEDULES_PVT dependencies on CN_RT_QUOTA_ASGNS

Line 106: FROM cn_rt_quota_asgns

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
106: FROM cn_rt_quota_asgns
107: WHERE rate_schedule_id = p_rate_schedule_id));
108: BEGIN
109: OPEN usage_check;
110: FETCH usage_check INTO x_usage_code;

Line 147: from cn_rate_schedules s, cn_rt_quota_asgns rqa

143: l_list wf_parameter_list_t;
144:
145: cursor get_rate_info is
146: select s.name, rqa.start_date, rqa.end_date, s.commission_unit_code, s.rate_schedule_id
147: from cn_rate_schedules s, cn_rt_quota_asgns rqa
148: where s.rate_schedule_id = rqa.rate_schedule_id
149: and rqa.rt_quota_asgn_id = p_rt_quota_asgn_id;
150: l_info_rec get_rate_info%rowtype;
151:

Line 1880: from cn_srp_quota_assigns sqa, cn_rt_quota_asgns rqa

1876: sqa.srp_quota_assign_id,
1877: sqa.quota_id,
1878: rqa.rt_quota_asgn_id,
1879: nvl(sqa.customized_flag, 'N') customized
1880: from cn_srp_quota_assigns sqa, cn_rt_quota_asgns rqa
1881: where rqa.rate_schedule_id = p_rate_schedule_id
1882: and sqa.quota_id = rqa.quota_id;
1883:
1884: BEGIN

Line 2041: from cn_srp_quota_assigns sqa, cn_rt_quota_asgns rqa

2037: end if;
2038:
2039: -- get rate schedule
2040: select rqa.rate_schedule_id into l_rate_schedule_id
2041: from cn_srp_quota_assigns sqa, cn_rt_quota_asgns rqa
2042: where rqa.rt_quota_asgn_id = p_rt_quota_asgn_id
2043: and sqa.quota_id = rqa.quota_id
2044: and sqa.srp_quota_assign_id = p_srp_quota_assign_id;
2045: