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 6376: pn_locations_all ploc

6372: pl.org_id
6373: FROM pn_leases pl,
6374: pn_lease_details_all pld,
6375: pn_var_rents_all pvr,
6376: pn_locations_all ploc
6377: WHERE pl.lease_id = pvr.lease_id
6378: AND pld.lease_id = pvr.lease_id
6379: AND ploc.location_id = pvr.location_id
6380: AND ploc.location_id IN (SELECT location_id

Line 6381: FROM pn_locations_all

6377: WHERE pl.lease_id = pvr.lease_id
6378: AND pld.lease_id = pvr.lease_id
6379: AND ploc.location_id = pvr.location_id
6380: AND ploc.location_id IN (SELECT location_id
6381: FROM pn_locations_all
6382: START WITH location_id
6383: IN
6384: (SELECT location_id
6385: FROM pn_locations_all

Line 6385: FROM pn_locations_all

6381: FROM pn_locations_all
6382: START WITH location_id
6383: IN
6384: (SELECT location_id
6385: FROM pn_locations_all
6386: WHERE property_id IN(SELECT property_id
6387: FROM pn_properties_all
6388: WHERE property_code=NVL(p_property_code,property_code)
6389: OR property_name=NVL(p_property_name,property_name))

Line 6412: pn_locations_all ploc

6408: pl.org_id
6409: FROM pn_leases pl,
6410: pn_lease_details_all pld,
6411: pn_var_rents_all pvr,
6412: pn_locations_all ploc
6413: WHERE pl.lease_id = pvr.lease_id
6414: AND pld.lease_id = pvr.lease_id
6415: AND ploc.location_id = pvr.location_id
6416: AND pl.lease_num >= NVL(p_lease_num_from, pl.lease_num)