DBA Data[Home] [Help]

APPS.POR_AME_REQ_WF_PVT dependencies on PO_REQUISITION_HEADERS_ALL

Line 433: from po_requisition_headers_all

429: begin
430:
431: select first_position_id, first_approver_id
432: into l_first_position_id, l_first_approver_id
433: from po_requisition_headers_all
434: where l_document_id = requisition_header_id;
435:
436: if (l_first_position_id is not NULL AND l_first_position_id=g_next_approvers(l_approver_index).orig_system_id ) then
437:

Line 880: from po_requisition_headers_all

876: aname => 'APPROVER_RESPONSE');
877:
878: select first_position_id, first_approver_id
879: into l_first_position_id, l_first_approver_id
880: from po_requisition_headers_all
881: where l_req_header_id = requisition_header_id;
882:
883: l_progress := 'Process_Beat_By_First: 003';
884: IF (g_po_wf_debug = 'Y') THEN

Line 2209: from po_requisition_headers_all

2205: l_approver_index := g_next_approvers.first();
2206:
2207: select first_position_id, first_approver_id
2208: into l_first_position_id, l_first_approver_id
2209: from po_requisition_headers_all
2210: where documentId = requisition_header_id;
2211:
2212: while( l_approver_index is not null ) loop
2213: l_position_has_valid_approvers := 'Y';