APPS.PO_DRAFT_APPR_STATUS_PVT dependencies on PO_HEADERS_DRAFT_ALL

Line 207: UPDATE po_headers_draft_all

203:
204: d_position := 100;
205: -- update draft table as well so that the merge statement would
206: -- not set the status back to its original one
207: UPDATE po_headers_draft_all
208: SET authorization_status = l_new_auth_status,
209: approved_flag = l_new_approved_flag,
210: last_update_date = SYSDATE
211: WHERE po_header_id = p_draft_info.po_header_id

Line 421: FROM po_headers_draft_all PHD,

417: INTO l_different
418: FROM dual
419: WHERE EXISTS
420: ( SELECT NULL
421: FROM po_headers_draft_all PHD,
422: po_headers_all PH
423: WHERE PHD.po_header_id = p_draft_info.po_header_id
424: AND PHD.draft_id = p_draft_info.draft_id
425: AND NVL(PHD.delete_flag, 'N') = 'N'