APPS.PO_HEADERS_SV5 dependencies on PO_RELEASES

Line 143: FROM PO_RELEASES PORH, PO_HEADERS POH

139:
140: CURSOR unapproved_releases IS
141: SELECT PORH.PO_release_ID,
142: POH.Type_Lookup_Code
143: FROM PO_RELEASES PORH, PO_HEADERS POH
144: WHERE NVL(PORH.authorization_status,'INCOMPLETE') IN
145: ('INCOMPLETE','REJECTED','REQUIRES REAPPROVAL')
146: AND NVL(PORH.cancel_flag,'N') = 'N'
147: AND NVL(PORH.closed_code,'OPEN') <> 'FINALLY CLOSED'

Line 424: from po_releases

420: end if;
421:
422: select wf_item_type,wf_item_key
423: into x_item_type,x_item_key
424: from po_releases
425: where po_release_id = l_doc_header_id;
426:
427: if (x_item_type is null and x_item_key is null ) then
428: po_approval_reminder_sv.cancel_notif(l_doc_subtype,l_doc_header_id,'Y');