APPS.PN_VAR_RENT_CALC_PKG dependencies on PN_PROPERTIES_ALL

Line 6387: FROM pn_properties_all

6383: IN
6384: (SELECT location_id
6385: FROM pn_locations_all
6386: WHERE property_id IN(SELECT property_id
6387: FROM pn_properties_all
6388: WHERE property_code=NVL(p_property_code,property_code)
6389: OR property_name=NVL(p_property_name,property_name))
6390: )
6391: CONNECT BY PRIOR location_id=parent_location_id)