eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_RT_QUOTA_ASGNS_PKG dependencies on CN_RT_QUOTA_ASGNS_ALL

Line 265: FROM cn_rt_quota_asgns_all

261: IS
262: CURSOR c
263: IS
264: SELECT *
265: FROM cn_rt_quota_asgns_all
266: WHERE rt_quota_asgn_id = x_rt_quota_asgn_id
267: FOR UPDATE OF rt_quota_asgn_id NOWAIT;
268:
269: recinfo c%ROWTYPE;

Line 453: FROM cn_rt_quota_asgns_all

449: IS
450: SELECT quota_id,
451: rate_schedule_id,
452: rt_quota_asgn_id
453: FROM cn_rt_quota_asgns_all
454: WHERE quota_id = x_quota_id AND calc_formula_id = x_calc_formula_id;
455:
456: recinfo srp_rate_insert_curs%ROWTYPE;
457:

Line 546: INSERT INTO cn_rt_quota_asgns_all

542: -- we only insert if there are overlap
543: -- clku, fix the date not overlap issue
544: IF ((l_start_date IS NOT NULL) AND (TRUNC (l_start_date) <= TRUNC (NVL (l_end_date, l_start_date))))
545: THEN
546: INSERT INTO cn_rt_quota_asgns_all
547: (rt_quota_asgn_id,
548: calc_formula_id,
549: quota_id,
550: start_date,