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_UPG_TRX_PKG dependencies on PN_LEASES

Line 31: FROM pn_leases pl,

27: IS
28:
29: CURSOR csr_get_vrent_wprop IS
30: SELECT pvr.var_rent_id
31: FROM pn_leases pl,
32: pn_var_rents_all pvr,
33: pn_locations_all ploc
34: WHERE pl.lease_id = pvr.lease_id
35: AND ploc.location_id = pvr.location_id

Line 58: FROM pn_leases pl,

54: ORDER BY pl.lease_id, pvr.var_rent_id;
55:
56: CURSOR csr_get_vrent_wloc IS
57: SELECT pvr.var_rent_id
58: FROM pn_leases pl,
59: pn_var_rents_all pvr,
60: pn_locations_all ploc
61: WHERE pl.lease_id = pvr.lease_id
62: AND ploc.location_id = pvr.location_id

Line 74: pn_leases_all pl

70:
71: CURSOR csr_get_vrent_woloc IS
72: SELECT pvr.var_rent_id
73: FROM pn_var_rents_all pvr,
74: pn_leases_all pl
75: WHERE pl.lease_id = pvr.lease_id
76: AND pl.lease_num >= NVL(p_lease_num_from, pl.lease_num)
77: AND pl.lease_num <= NVL(p_lease_num_to, pl.lease_num)
78: AND pvr.rent_num >= NVL(p_vrent_num_from,pvr.rent_num)