APPS.PO_AME_SETUP_PVT dependencies on PO_DOCUMENT_TYPES_ALL_B

Line 357: l_can_approve po_document_types_all_b.can_preparer_approve_flag%TYPE;

353: --End of Comments
354: -------------------------------------------------------------------------------
355: FUNCTION can_preparer_approve(reqHeaderId IN NUMBER)
356: RETURN VARCHAR2 IS
357: l_can_approve po_document_types_all_b.can_preparer_approve_flag%TYPE;
358:
359: BEGIN
360: SELECT NVL(pdt.can_preparer_approve_flag, 'N')
361: INTO l_can_approve

Line 362: FROM po_document_types_all_b pdt, po_requisition_headers_all prh

358:
359: BEGIN
360: SELECT NVL(pdt.can_preparer_approve_flag, 'N')
361: INTO l_can_approve
362: FROM po_document_types_all_b pdt, po_requisition_headers_all prh
363: WHERE prh.requisition_header_id = reqHeaderId and
364: pdt.org_id = prh.org_id and --
365: prh.type_lookup_code = pdt.document_subtype and
366: pdt.DOCUMENT_TYPE_CODE='REQUISITION';