112:
113: select decode(hrtl.description,null,'',hrtl.description)
114: into value
115: from
116: hr_locations_all_tl hrtl,
117: po_requisition_lines_all prl
118: where
119: hrtl.location_id = prl.deliver_to_location_id AND
120: prl.requisition_header_id = req_header_id AND
125:
126: select hrl.location_id
127: into l_location_id
128: from
129: hr_locations hrl,
130: po_requisition_lines_all prl
131: where
132: hrl.location_id = prl.deliver_to_location_id AND
133: prl.requisition_header_id = req_header_id AND