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.

[Home] [Help]

APPS.PN_SCHEDULES_ITEMS dependencies on PN_VAR_RENTS_ALL

Line 6171: FROM pn_var_rents_all pvr

6167: /* -- CURSORS -- */
6168:
6169: CURSOR get_vr_cur(p_term_id IN NUMBER) IS
6170: SELECT pvr.rent_num
6171: FROM pn_var_rents_all pvr
6172: ,pn_var_rent_inv_all pvri
6173: ,pn_var_abatements_all pva
6174: ,pn_payment_terms_all ppt
6175: WHERE ppt.payment_term_id = p_term_id

Line 7032: FROM pn_var_rents_all

7028:
7029: CURSOR var_cur(p1_lease_id IN NUMBER)
7030: IS
7031: SELECT var_rent_id
7032: FROM pn_var_rents_all
7033: WHERE lease_id = p1_lease_id;
7034:
7035: CURSOR terms_cur (p1_lease_id IN NUMBER)
7036: IS