DBA Data[Home] [Help]

APPS.PN_APPROVE_VARENT_PKG dependencies on PN_LOCATIONS_ALL

Line 59: pn_locations_all ploc

55: pl.status
56: FROM pn_leases pl,
57: pn_lease_details_all pld,
58: pn_var_rents_all pvr,
59: pn_locations_all ploc
60: WHERE pl.lease_id = pvr.lease_id
61: AND pld.lease_id = pvr.lease_id
62: AND ploc.location_id = pvr.location_id
63: AND pl.lease_num >= NVL(p_lease_num_from, pl.lease_num)