APPS.CN_SRP_RATE_ASSIGNS_PKG dependencies on CN_RT_QUOTA_ASGNS_ALL

Line 211: ,cn_rt_quota_asgns_all rqa

207: ,l_login_id
208: ,qa.org_id
209: FROM cn_rate_tiers_all t
210: ,cn_srp_quota_assigns_all qa
211: ,cn_rt_quota_asgns_all rqa
212: WHERE qa.srp_plan_assign_id = x_srp_plan_assign_id
213: AND qa.quota_id = x_quota_id
214: AND rqa.quota_id = x_quota_id
215: AND rqa.quota_id = qa.quota_id

Line 260: ,cn_rt_quota_asgns_all rqa

256: ,l_login_id
257: ,qa.org_id
258: FROM cn_rate_tiers_all t
259: ,cn_srp_quota_assigns_all qa
260: ,cn_rt_quota_asgns_all rqa
261: WHERE qa.srp_plan_assign_id = x_srp_plan_assign_id
262: AND qa.quota_id = rqa.quota_id
263: AND rqa.rate_schedule_id = t.rate_schedule_id
264: AND qa.customized_flag = 'Y'

Line 308: ,cn_rt_quota_asgns_all rqa

304: ,l_login_id
305: ,qa.org_id
306: FROM cn_rate_tiers_all t
307: ,cn_srp_quota_assigns_all qa
308: ,cn_rt_quota_asgns_all rqa
309: WHERE qa.quota_id = x_quota_id
310: AND rqa.quota_id = x_quota_Id
311: AND rqa.quota_id = qa.quota_id
312: AND rqa.rate_schedule_id = x_rate_schedule_id

Line 356: ,cn_rt_quota_asgns_all rqa

352: ,l_login_id
353: ,qa.org_id
354: FROM cn_rate_tiers_all t
355: ,cn_srp_quota_assigns_all qa
356: ,cn_rt_quota_asgns_all rqa
357: WHERE qa.quota_id = x_quota_id
358: AND rqa.quota_id = x_quota_Id
359: AND rqa.quota_id = qa.quota_id
360: AND rqa.rate_schedule_id = x_rate_schedule_id

Line 407: ,cn_rt_quota_asgns_all rqa

403: ,l_login_id
404: ,qa.org_id
405: FROM cn_rate_tiers_all t
406: ,cn_srp_quota_assigns_all qa
407: ,cn_rt_quota_asgns_all rqa
408: WHERE rqa.rate_schedule_id = t.rate_schedule_id
409: AND rqa.quota_id = qa.quota_id
410: AND t.rate_tier_id = x_rate_tier_id
411: AND t.rate_schedule_id = x_rate_schedule_id