APPS.PO_POAPPROVAL_INIT1 dependencies on PO_REQUISITION_HEADERS

Line 1273: FROM po_requisition_headers

1269:
1270: ELSIF (doc_type_code = 'REQUISITION') THEN
1271: SELECT type_lookup_code
1272: INTO l_doc_subtype
1273: FROM po_requisition_headers
1274: WHERE requisition_header_id = doc_header_id;
1275:
1276: ELSE
1277: wf_core.context('PO_POAPPROVAL_INIT1',

Line 1854: l_req_header_id PO_REQUISITION_HEADERS_ALL.requisition_header_id%TYPE;

1850: l_progress VARCHAR2(3) := '000';
1851: l_requester_user_name WF_USERS.name%TYPE;
1852: l_requester_disp_name WF_USERS.display_name%TYPE;
1853: l_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
1854: l_req_header_id PO_REQUISITION_HEADERS_ALL.requisition_header_id%TYPE;
1855: l_document_number PO_HEADERS_ALL.segment1%TYPE;
1856: l_create_cwk_url VARCHAR2(500);
1857: BEGIN
1858: IF (g_po_wf_debug = 'Y') THEN