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.PN_VAR_DEFAULTS_PKG dependencies on PN_VAR_PERIODS_ALL

Line 354: from pn_var_periods_all

350: l_end_date DATE := NULL;
351:
352: cursor c1 (p_start DATE, p_end DATE, p_defid NUMBER) is
353: select distinct period_id, start_date, end_date
354: from pn_var_periods_all
355: where var_rent_id = l_var_rent_id
356: and start_date <= p_end
357: and end_date >= p_start
358: and period_id not in (select period_id

Line 510: from pn_var_periods_all a,

506: select a.period_id,
507: a.start_date,
508: a.end_date,
509: b.reptg_freq_code
510: from pn_var_periods_all a,
511: pn_var_rent_dates_all b
512: where a.var_rent_id = l_var_rent_id
513: and a.var_rent_id = b.var_rent_id;
514:

Line 2054: FROM pn_var_periods_all a

2050: IS
2051: SELECT a.period_id,
2052: a.start_date,
2053: a.end_date
2054: FROM pn_var_periods_all a
2055: WHERE a.var_rent_id = l_var_rent_id
2056: AND a.status IS NULL;
2057:
2058: