APPS.PN_VAR_TRUEUP_PKG dependencies on PN_LOCATIONS_ALL

Line 2843: pn_locations_all

2839: vr.location_id IN
2840: (SELECT
2841: location_id
2842: FROM
2843: pn_locations_all
2844: START WITH location_id = p_building_id
2845: CONNECT BY PRIOR location_id = parent_location_id)
2846: ORDER BY
2847: vr.rent_num;

Line 2853: pn_locations_all loc

2849: CURSOR get_buildings_c(p_prop_code IN VARCHAR2) IS
2850: SELECT DISTINCT
2851: loc.location_id
2852: FROM
2853: pn_locations_all loc
2854: ,pn_properties_all prop
2855: WHERE
2856: loc.property_id = prop.property_id AND
2857: prop.property_code = p_prop_code;