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_CHG_CAL_PKG dependencies on PN_VAR_RENT_INV_ALL

Line 3763: FROM pn_var_rent_inv_all

3759:
3760: CURSOR invoices_cur (ip_invoice_date DATE) IS
3761: SELECT decode(actual_Exp_code ,'Y',NVL(actual_invoiced_amount,0),0) invoiced_amt
3762: ,invoice_date
3763: FROM pn_var_rent_inv_all
3764: WHERE var_rent_id = p_var_rent_id
3765: AND invoice_date >= ip_invoice_date;
3766:
3767: CURSOR max_invoice_date_cur Is

Line 3781: FROM pn_var_rent_inv_all

3777: AND ip_date between start_date and end_date ;
3778:
3779: CURSOR get_adjust_num ( ip_period_id NUMBER , ip_invoice_date DATE) IS
3780: SELECT max(adjust_num) adjust_num
3781: FROM pn_var_rent_inv_all
3782: WHERE period_id = ip_period_id
3783: AND invoice_date = ip_invoice_date;
3784:
3785: l_proration_factor NUMBER;