APPS.POS_WF_PO_ACK dependencies on PO_RELEASES

Line 185: from po_releases_all por,

181: select por.release_num, por.agent_id, poh.segment1 || '-' || poh.revision_num, polc.displayed_field,
182: por.acceptance_required_flag, por.acceptance_due_date, por.agent_id
183: into x_release_num, x_agent_id, x_document_num, x_document_type, x_acceptance_required_flag,
184: x_acceptance_due_date, x_agent_id
185: from po_releases_all por,
186: po_headers_all poh,
187: po_lookup_codes polc
188: where por.po_release_id = x_document_id
189: and por.po_header_id = poh.po_header_id

Line 316: from po_releases

312: x_Po_Release_Id := x_document_id;
313:
314: select po_header_id, revision_num
315: into x_Po_Header_Id, x_revision_num
316: from po_releases
317: where po_release_id = x_document_id;
318: end if;
319:
320: INSERT INTO PO_ACCEPTANCES(acceptance_id,

Line 411: from po_releases

407:
408: if document_type = 'RELEASE' then
409: select nvl(acceptance_required_flag, 'N')
410: into x_acceptance_required
411: from po_releases
412: where po_release_id = document_id;
413: else
414: select nvl(acceptance_required_flag, 'N')
415: into x_acceptance_required

Line 504: from po_releases_all por,

500: por.acceptance_required_flag, por.acceptance_due_date, por.agent_id
501: into x_release_num, x_agent_id, x_document_num, x_document_type,
502: x_acceptance_required_flag,
503: x_acceptance_due_date, x_agent_id
504: from po_releases_all por,
505: po_headers_all poh,
506: po_lookup_codes polc
507: where por.po_release_id = x_document_id
508: and por.po_header_id = poh.po_header_id