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_APPROVE_VARENT_PKG dependencies on PN_VAR_RENTS_ALL

Line 58: pn_var_rents_all pvr,

54: pvr.invoice_on,
55: pl.status
56: FROM pn_leases pl,
57: pn_lease_details_all pld,
58: pn_var_rents_all pvr,
59: pn_locations_all ploc
60: WHERE pl.lease_id = pvr.lease_id
61: AND pld.lease_id = pvr.lease_id
62: AND ploc.location_id = pvr.location_id

Line 79: pn_var_rents_all pvr,

75: pvr.rent_num,
76: pvr.invoice_on,
77: pl.status
78: FROM pn_leases pl,
79: pn_var_rents_all pvr,
80: pn_lease_details_all pld
81: WHERE pl.lease_id = pvr.lease_id
82: AND pld.lease_id = pvr.lease_id
83: AND pl.lease_num >= NVL(p_lease_num_from, pl.lease_num)

Line 473: FROM pn_var_periods_all pvp, pn_var_rents_all pvr

469: -- Get the details of
470: CURSOR period_FY_cur(p_period_id NUMBER,
471: p_var_rent_id NUMBER) IS
472: SELECT period_id
473: FROM pn_var_periods_all pvp, pn_var_rents_all pvr
474: WHERE pvr.var_rent_id = pvp.var_rent_id
475: AND pvp.period_id = p_period_id
476: AND pvr.var_rent_id = p_var_rent_id
477: AND pvr.proration_rule IN ('FLY', 'FY')