DBA Data[Home] [Help]

APPS.PN_VARIABLE_AMOUNT_PKG dependencies on PN_LOCATIONS_ALL

Line 2304: pn_locations_all ploc

2300: pl.org_id
2301: FROM pn_leases pl,
2302: pn_lease_details_all pld,
2303: pn_var_rents_all pvr,
2304: pn_locations_all ploc
2305: WHERE pl.lease_id = pvr.lease_id
2306: AND pld.lease_id = pvr.lease_id
2307: AND ploc.location_id = pvr.location_id
2308: AND pl.lease_num >= NVL(p_lease_num_from, pl.lease_num)