DBA Data[Home] [Help]

APPS.PO_APPROVAL_ACTION dependencies on PO_RELEASES

Line 110: FROM PO_RELEASES POR

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'),

Line 160: from po_releases por,

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,