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_RENT_CALC_PKG dependencies on PN_LOCATIONS_ALL

Line 6418: pn_locations_all ploc

6414: pl.org_id
6415: FROM pn_leases pl,
6416: pn_lease_details_all pld,
6417: pn_var_rents_all pvr,
6418: pn_locations_all ploc
6419: WHERE pl.lease_id = pvr.lease_id
6420: AND pld.lease_id = pvr.lease_id
6421: AND ploc.location_id = pvr.location_id
6422: AND ploc.location_id IN (SELECT location_id

Line 6423: FROM pn_locations_all

6419: WHERE pl.lease_id = pvr.lease_id
6420: AND pld.lease_id = pvr.lease_id
6421: AND ploc.location_id = pvr.location_id
6422: AND ploc.location_id IN (SELECT location_id
6423: FROM pn_locations_all
6424: START WITH location_id
6425: IN
6426: (SELECT location_id
6427: FROM pn_locations_all

Line 6427: FROM pn_locations_all

6423: FROM pn_locations_all
6424: START WITH location_id
6425: IN
6426: (SELECT location_id
6427: FROM pn_locations_all
6428: WHERE property_id IN(SELECT property_id
6429: FROM pn_properties_all
6430: WHERE property_code=NVL(l_prop_code,property_code))
6431: --OR property_name=NVL(p_property_name,property_name)) /* 9765197 */

Line 6454: pn_locations_all ploc

6450: pl.org_id
6451: FROM pn_leases pl,
6452: pn_lease_details_all pld,
6453: pn_var_rents_all pvr,
6454: pn_locations_all ploc
6455: WHERE pl.lease_id = pvr.lease_id
6456: AND pld.lease_id = pvr.lease_id
6457: AND ploc.location_id = pvr.location_id
6458: AND pl.lease_num >= NVL(p_lease_num_from, pl.lease_num)