APPS.PN_VAR_TRUEUP_PKG dependencies on PN_LOCATIONS_ALL

Line 2841: pn_locations_all

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

Line 2851: pn_locations_all loc

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