DBA Data[Home] [Help]

APPS.CLN_PO_CHANGE_RESPONSE_PKG dependencies on PO_RELEASES_ALL

Line 92: select revision_num into l_revision_num from po_releases_all where po_release_id = l_release_id;

88: WHERE change_request_group_id = l_change_request_group_id;
89:
90: -- Get the revision number
91: IF l_release_id is not null and l_release_id > 0 THEN
92: select revision_num into l_revision_num from po_releases_all where po_release_id = l_release_id;
93: ELSE
94: select revision_num into l_revision_num from po_headers_all where po_header_id = l_header_id;
95: END IF;
96: