APPS.PO_AME_SETUP_PVT dependencies on PO_DOCUMENT_TYPES_ALL_B

Line 485: l_can_approve po_document_types_all_b.can_preparer_approve_flag%TYPE;

481: --End of Comments
482: -------------------------------------------------------------------------------
483: FUNCTION can_preparer_approve(reqHeaderId IN NUMBER)
484: RETURN VARCHAR2 IS
485: l_can_approve po_document_types_all_b.can_preparer_approve_flag%TYPE;
486:
487: BEGIN
488: SELECT NVL(pdt.can_preparer_approve_flag, 'N')
489: INTO l_can_approve

Line 490: FROM po_document_types_all_b pdt, po_requisition_headers_all prh

486:
487: BEGIN
488: SELECT NVL(pdt.can_preparer_approve_flag, 'N')
489: INTO l_can_approve
490: FROM po_document_types_all_b pdt, po_requisition_headers_all prh
491: WHERE prh.requisition_header_id = reqHeaderId and
492: pdt.org_id = prh.org_id and --
493: prh.type_lookup_code = pdt.document_subtype and
494: pdt.DOCUMENT_TYPE_CODE='REQUISITION';

Line 528: l_can_approve po_document_types_all_b.can_preparer_approve_flag%TYPE;

524: --End of Comments
525: -------------------------------------------------------------------------------
526: FUNCTION can_preparer_approve_po(ameApprovalId IN NUMBER)
527: RETURN VARCHAR2 IS
528: l_can_approve po_document_types_all_b.can_preparer_approve_flag%TYPE;
529:
530: BEGIN
531: SELECT NVL(pdt.can_preparer_approve_flag, 'N')
532: INTO l_can_approve

Line 533: FROM po_document_types_all_b pdt, po_headers_merge_v phm

529:
530: BEGIN
531: SELECT NVL(pdt.can_preparer_approve_flag, 'N')
532: INTO l_can_approve
533: FROM po_document_types_all_b pdt, po_headers_merge_v phm
534: WHERE phm.ame_approval_id = ameApprovalId and
535: pdt.org_id = phm.org_id and --
536: phm.type_lookup_code = pdt.document_subtype and
537: pdt.DOCUMENT_TYPE_CODE in ('PO','PA');