2298: pvr.cumulative_vol,
2299: pvr.rent_num,
2300: pl.org_id
2301: FROM pn_leases pl,
2302: pn_lease_details_all pld,
2303: pn_var_rents_all pvr,
2304: pn_locations_all ploc
2305: WHERE pl.lease_id = pvr.lease_id
2306: AND pld.lease_id = pvr.lease_id
2323: pvr.rent_num,
2324: pl.org_id
2325: FROM pn_var_rents_all pvr,
2326: pn_leases pl,
2327: pn_lease_details_all pld
2328: WHERE pl.lease_id = pvr.lease_id
2329: AND pld.lease_id = pvr.lease_id
2330: AND pl.lease_num >= NVL(p_lease_num_from, pl.lease_num)
2331: AND pl.lease_num <= NVL(p_lease_num_to, pl.lease_num)