APPS.POR_WITHDRAW_REQ_SV dependencies on PO_APPROVAL_LIST_HEADERS

Line 83: from po_approval_list_headers

79:
80: delete po_approval_list_lines
81: where APPROVAL_LIST_HEADER_ID in
82: ( select approval_list_header_id
83: from po_approval_list_headers
84: where document_id = p_existing_requisition_id
85: and document_type = 'REQUISITION');
86:
87: delete po_approval_list_headers

Line 87: delete po_approval_list_headers

83: from po_approval_list_headers
84: where document_id = p_existing_requisition_id
85: and document_type = 'REQUISITION');
86:
87: delete po_approval_list_headers
88: where document_id = p_existing_requisition_id
89: and document_type = 'REQUISITION';
90:
91: update PO_REQUISITION_LINES_ALL

Line 101: update po_approval_list_headers

97: SEGMENT1 = l_req_number,
98: AUTHORIZATION_STATUS = 'INCOMPLETE'
99: where REQUISITION_HEADER_ID = p_new_requisition_id;
100:
101: update po_approval_list_headers
102: set document_id = p_existing_requisition_id
103: where document_id = p_new_requisition_id;
104:
105: /* bug 2338259 */