DBA Data[Home] [Help]

APPS.PO_POAPPROVAL_INIT1 dependencies on PO_REQUISITION_HEADERS

Line 1041: FROM po_requisition_headers

1037:
1038: ELSIF (doc_type_code = 'REQUISITION') THEN
1039: SELECT type_lookup_code
1040: INTO l_doc_subtype
1041: FROM po_requisition_headers
1042: WHERE requisition_header_id = doc_header_id;
1043:
1044: ELSE
1045: wf_core.context('PO_POAPPROVAL_INIT1',

Line 1610: l_req_header_id PO_REQUISITION_HEADERS_ALL.requisition_header_id%TYPE;

1606: l_progress VARCHAR2(3) := '000';
1607: l_requester_user_name WF_USERS.name%TYPE;
1608: l_requester_disp_name WF_USERS.display_name%TYPE;
1609: l_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
1610: l_req_header_id PO_REQUISITION_HEADERS_ALL.requisition_header_id%TYPE;
1611: l_document_number PO_HEADERS_ALL.segment1%TYPE;
1612: l_create_cwk_url VARCHAR2(500);
1613: BEGIN
1614: IF (g_po_wf_debug = 'Y') THEN