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_ABATEMENTS_PKG dependencies on PN_VAR_PERIODS_ALL

Line 705: pn_var_periods_all vp,

701: /*Cursor to get all invoices from 2nd annual period*/
702: CURSOR get_all_inv(p_var_rent_id IN NUMBER) IS
703: SELECT distinct gd1.invoice_date,decode(temp.inv_id,NULL,-1,temp.inv_id) v_inv_id
704: FROM pn_var_grp_dates_all gd1,
705: pn_var_periods_all vp,
706: (SELECT gd.invoice_date inv_dt,vinv.var_rent_inv_id inv_id
707: FROM pn_var_grp_dates_all gd , pn_var_rent_inv_all vinv
708: WHERE vinv.var_rent_id=gd.var_rent_id
709: AND vinv.invoice_date=gd.invoice_date