APPS.PN_VAR_NATURAL_BP_PKG dependencies on PN_LEASES_ALL

Line 585: FROM pn_leases_all

581: SELECT distinct lease_id
582: FROM
583: (
584: SELECT lease_id
585: FROM pn_leases_all
586: WHERE location_id in (SELECT location_id
587: FROM pn_locations_all loc
588: START with loc.location_id in (SELECT location_id
589: FROM pn_locations_all

Line 611: FROM pn_leases_all

607: FROM pn_tenancies_all
608: WHERE location_id = p_loc_id
609: UNION
610: SELECT lease_id
611: FROM pn_leases_all
612: WHERE location_id = p_loc_id
613: );
614:
615: