DBA Data[Home] [Help]

APPS.POR_AMENDMENT_PKG dependencies on PO_DRAFTS

Line 7469: FROM po_drafts DFT

7465: BEGIN
7466:
7467: SELECT draft_id
7468: INTO p_draft_id
7469: FROM po_drafts DFT
7470: WHERE DFT.document_id = p_req_header_id
7471: AND DFT.status in ('DRAFT')
7472: AND DFT.creation_date = (SELECT Max(creation_date)
7473: FROM po_drafts

Line 7473: FROM po_drafts

7469: FROM po_drafts DFT
7470: WHERE DFT.document_id = p_req_header_id
7471: AND DFT.status in ('DRAFT')
7472: AND DFT.creation_date = (SELECT Max(creation_date)
7473: FROM po_drafts
7474: WHERE document_id = p_req_header_id
7475: AND status in ('DRAFT'));
7476:
7477: EXCEPTION