APPS.PO_DOCUMENT_CHECKS_PVT dependencies on PO_HEADERS_DRAFT_ALL

Line 21918: FROM PO_HEADERS_DRAFT_ALL PHA

21914:
21915: ELSE
21916: SELECT PHA.VENDOR_SITE_ID
21917: INTO l_vendor_site_id
21918: FROM PO_HEADERS_DRAFT_ALL PHA
21919: WHERE PHA.PO_HEADER_ID = p_header_id AND PHA.draft_id = p_draft_id;
21920:
21921: END IF;
21922:

Line 22314: FROM po_headers_draft_all phm

22310: ELSE
22311: -- Finding the mod amount, agreed amount in the case of PA
22312: SELECT nvl(BLANKET_TOTAL_AMOUNT, 0)
22313: INTO l_doc_amount
22314: FROM po_headers_draft_all phm
22315: WHERE phm.po_header_id = p_header_id
22316: AND phm.draft_id = p_draft_id;
22317: END IF;
22318: END IF; -- l_type_lookup_code = 'STANDARD' THEN

Line 26576: FROM po_headers_draft_all phda, po_headers_all phd,

26572: ELSE
26573: Nvl(pod.changed_amt,0)
26574: END) changed_amt -- Bug 16713804
26575: INTO l_okc_doc_type,l_changed_amt
26576: FROM po_headers_draft_all phda, po_headers_all phd,
26577: po_drafts pod
26578: WHERE phda.po_header_id = p_document_id
26579: AND phd.po_header_id = phda.po_header_id
26580: AND phda.draft_id = p_draft_id