APPS.PO_REQAPPROVAL_FINDAPPRV1 dependencies on PO_DOCUMENT_TYPES

Line 1610: FROM po_document_types podt

1606:
1607: x_progress := '002';
1608:
1609: Select default_approval_path_id into l_approval_path_id
1610: FROM po_document_types podt
1611: WHERE podt.document_type_code = l_document_type_code
1612: AND podt.document_subtype = l_document_subtype;
1613:
1614: wf_engine.SetItemAttrNumber (itemtype => itemtype,

Line 1656: from po_document_types

1652: itemkey => itemkey,
1653: aname => 'DOCUMENT_SUBTYPE');
1654:
1655: SELECT FORWARDING_MODE_CODE into l_forward_mode
1656: from po_document_types
1657: where document_subtype = l_document_subtype
1658: and document_type_code = l_document_type_code;
1659:
1660: RETURN(l_forward_mode);

Line 2252: from po_document_types

2248: CanOwnerApprove out NOCOPY VARCHAR2) is
2249:
2250: Cursor C1(p_document_type_code VARCHAR2, p_document_subtype VARCHAR2) is
2251: select NVL(can_preparer_approve_flag,'N')
2252: from po_document_types
2253: where document_type_code = p_document_type_code
2254: and document_subtype = p_document_subtype;
2255:
2256: l_document_type_code VARCHAR2(25);