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_MASS_APPR_PKG dependencies on PN_TENANCIES_ALL

Line 282: pn_tenancies_all pt,

278: pl.name s_lease_name
279: FROM pn_payment_schedules_all pps,
280: pn_leases pl,
281: pn_lease_details_all pld,
282: pn_tenancies_all pt,
283: pn_locations_all ploc
284: WHERE pps.schedule_date BETWEEN NVL(p_schedule_from_date, pps.schedule_date)
285: AND NVL(p_schedule_to_date, pps.schedule_date)
286: AND pps.payment_status_lookup_code = 'DRAFT'

Line 875: pn_tenancies_all pt,

871: pl.lease_id s_lease_id
872: FROM pn_payment_schedules_all pps,
873: pn_leases pl,
874: pn_lease_details_all pld,
875: pn_tenancies_all pt,
876: pn_locations_all ploc
877: WHERE pps.schedule_date BETWEEN NVL(p_schedule_from_date, pps.schedule_date)
878: AND NVL(p_schedule_to_date, pps.schedule_date)
879: AND pps.payment_status_lookup_code = 'APPROVED'