106: INTO l_authorization_status,
107: l_head_closed,
108: l_frozen_flag,
109: l_user_hold_flag
110: FROM PO_RELEASES POR
111: WHERE POR.po_release_id = l_document_id;
112: else
113: SELECT nvl(POH.authorization_status,'INCOMPLETE'),
114: nvl(POH.closed_code,'OPEN'),
156: begin
157: if (doctype = 'RELEASE') then
158: select 'Y'
159: into l_code_exist
160: from po_releases por,
161: po_lookup_codes plc_sta,
162: po_lookup_codes plc_can,
163: po_lookup_codes plc_clo,
164: po_lookup_codes plc_fro,