APPS.RRS_SITE_UTILS dependencies on PN_PROPERTIES_ALL

Line 405: ,pn_properties_all prop

401: IS
402: CURSOR c_property_name(c_location_id NUMBER) IS
403: SELECT prop.property_name
404: FROM pn_locations_all pn
405: ,pn_properties_all prop
406: WHERE pn.location_id = c_location_id
407: AND prop.property_id = pn.property_id ;
408:
409: l_property_name pn_properties_all.property_name%type ;

Line 409: l_property_name pn_properties_all.property_name%type ;

405: ,pn_properties_all prop
406: WHERE pn.location_id = c_location_id
407: AND prop.property_id = pn.property_id ;
408:
409: l_property_name pn_properties_all.property_name%type ;
410:
411: BEGIN
412: OPEN c_property_name(p_location_id);
413: FETCH c_property_name INTO l_property_name ;