DBA Data[Home] [Help]

APPS.POR_AME_RCO_WF_PVT dependencies on PO_REQUISITION_HEADERS_ALL

Line 403: from po_requisition_headers_all

399: begin
400:
401: select first_position_id, first_approver_id
402: into l_first_position_id, l_first_approver_id
403: from po_requisition_headers_all
404: where l_document_id = requisition_header_id;
405:
406: if (l_first_position_id is not NULL AND l_first_position_id=g_next_approvers(l_approver_index).orig_system_id ) then
407:

Line 1667: from po_requisition_headers_all

1663: l_approver_index := g_next_approvers.first();
1664:
1665: select first_position_id, first_approver_id
1666: into l_first_position_id, l_first_approver_id
1667: from po_requisition_headers_all
1668: where documentId = requisition_header_id;
1669:
1670: while( l_approver_index is not null ) loop
1671: l_position_has_valid_approvers := 'Y';