DBA Data[Home] [Help]

APPS.CN_SRP_RATE_ASSIGNS_PKG dependencies on CN_RATE_TIERS_ALL

Line 209: FROM cn_rate_tiers_all t

205: ,sysdate
206: ,l_user_id
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

Line 258: FROM cn_rate_tiers_all t

254: ,sysdate
255: ,l_user_id
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

Line 306: FROM cn_rate_tiers_all t

302: ,sysdate
303: ,l_user_id
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

Line 354: FROM cn_rate_tiers_all t

350: ,sysdate
351: ,l_user_id
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

Line 405: FROM cn_rate_tiers_all t

401: ,sysdate
402: ,l_user_id
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