DBA Data[Home] [Help]

APPS.POR_VIEW_REQS_PKG dependencies on HR_LOCATIONS

Line 116: hr_locations_all_tl hrtl,

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

Line 129: hr_locations hrl,

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