APPS.PO_POAPPROVAL_INIT1 dependencies on PO_RELEASES

Line 43: from po_releases_all PORL, po_headers_all POH

39: select PORL.PO_RELEASE_ID,PORL.PO_HEADER_ID,PORL.AUTHORIZATION_STATUS,
40: PORL.RELEASE_TYPE,PORL.AGENT_ID,PORL.RELEASE_NUM,PORL.CLOSED_CODE,
41: POH.SEGMENT1, POH.CURRENCY_CODE, POH.COMMENTS
42: -- Bug 10140786 Selected comments to set PO_DESCRIPTION in release workflow.
43: from po_releases_all PORL, po_headers_all POH
44: where PORL.PO_RELEASE_ID = p_rel_header_id
45: and PORL.po_header_id = POH.po_header_id;
46:
47: -- The following are local/Private procedure that support the workflow APIs:

Line 150: FROM po_releases_all

146: ELSIF l_doc_type in ('RELEASE') THEN
147:
148: SELECT (Nvl (comm_rev_num, -1))
149: INTO l_po_revision_num_orig
150: FROM po_releases_all
151: WHERE po_release_id = l_po_header_id;
152:
153: END IF;
154:

Line 393: from po_releases

389: ELSIF l_doc_type='RELEASE' THEN
390:
391: select acceptance_required_flag,acceptance_due_date
392: into l_acceptance_required, l_acceptance_due_date
393: from po_releases
394: where po_release_id= l_po_header_id;
395:
396: END IF;
397:

Line 2041: FROM po_releases_all

2037:
2038: IF (p_doc_type = 'RELEASE') THEN
2039: SELECT approved_date
2040: INTO x_approved_date
2041: FROM po_releases_all
2042: WHERE po_release_id = p_doc_id;
2043: ELSE
2044: SELECT approved_date
2045: INTO x_approved_date