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_INDEX_RENT_UTILS dependencies on PN_LEASES_ALL

Line 244: FROM pn_leases_all PL

240: ,PLD.lease_commencement_date commencement_date
241: ,PLD.lease_termination_date termination_date
242: ,PLD.lease_execution_date lease_execution_date
243: ,PLD.lease_extension_end_date
244: FROM pn_leases_all PL
245: ,pn_lease_details_all PLD
246: WHERE PLD.lease_id = PL.lease_id
247: AND PL.lease_id = x_lease_id
248: AND PLD.org_id = PL.org_id

Line 259: FROM pn_leases_all PL

255: ,PLD.lease_commencement_date commencement_date
256: ,PLD.lease_termination_date termination_date
257: ,PLD.lease_execution_date lease_execution_date
258: ,PLD.lease_extension_end_date
259: FROM pn_leases_all PL
260: ,pn_lease_details_all PLD
261: WHERE PL.lease_num = p_lease_number
262: AND PLD.lease_id = PL.lease_id
263: -- AND PL.lease_id = x_lease_id

Line 276: FROM pn_leases_all PL

272: ,PLD.lease_commencement_date commencement_date
273: ,PLD.lease_termination_date termination_date
274: ,PLD.lease_execution_date lease_execution_date
275: ,PLD.lease_extension_end_date
276: FROM pn_leases_all PL
277: ,pn_lease_details_all PLD
278: WHERE PL.name = p_lease_name
279: AND PLD.lease_id = PL.lease_id
280: --AND PL.lease_id = x_lease_id