APPS.PO_REQAPPROVAL_FINDAPPRV1 dependencies on PO_DOCUMENT_TYPES

Line 1468: FROM po_document_types podt

1464:
1465: x_progress := '002';
1466:
1467: Select default_approval_path_id into l_approval_path_id
1468: FROM po_document_types podt
1469: WHERE podt.document_type_code = l_document_type_code
1470: AND podt.document_subtype = l_document_subtype;
1471:
1472: wf_engine.SetItemAttrNumber (itemtype => itemtype,

Line 1514: from po_document_types

1510: itemkey => itemkey,
1511: aname => 'DOCUMENT_SUBTYPE');
1512:
1513: SELECT FORWARDING_MODE_CODE into l_forward_mode
1514: from po_document_types
1515: where document_subtype = l_document_subtype
1516: and document_type_code = l_document_type_code;
1517:
1518: RETURN(l_forward_mode);

Line 2066: from po_document_types

2062: CanOwnerApprove out NOCOPY VARCHAR2) is
2063:
2064: Cursor C1(p_document_type_code VARCHAR2, p_document_subtype VARCHAR2) is
2065: select NVL(can_preparer_approve_flag,'N')
2066: from po_document_types
2067: where document_type_code = p_document_type_code
2068: and document_subtype = p_document_subtype;
2069:
2070: l_document_type_code VARCHAR2(25);