APPS.POR_PURGE_SYS_SAVED_REQ dependencies on PO_REQUISITION_HEADERS_ALL

Line 8: from po_requisition_headers_all prh, po_requisition_lines_all prl

4: PROCEDURE purge_req(x_updated_days IN NUMBER default 1) is
5:
6: cursor c_req (p_date number) is
7: select distinct prh.requisition_header_id
8: from po_requisition_headers_all prh, po_requisition_lines_all prl
9: where prh.authorization_status ='SYSTEM_SAVED'
10: and prh.requisition_header_id = prl.requisition_header_id (+)
11: and prh.last_update_date < (sysdate-p_date)
12: and prl.line_location_id is null

Line 17: from po_requisition_headers_all

13: order by prh.requisition_header_id;
14:
15: /*
16: select requisition_header_id
17: from po_requisition_headers_all
18: where authorization_status ='SYSTEM_SAVED'
19: and last_update_date < (sysdate-p_date)
20: order by requisition_header_id;
21: */

Line 74: delete PO_REQUISITION_HEADERS_ALL

70:
71: delete PO_REQUISITION_LINES_ALL
72: where REQUISITION_HEADER_ID = syssaved_req_header_id;
73:
74: delete PO_REQUISITION_HEADERS_ALL
75: where REQUISITION_HEADER_ID = syssaved_req_header_id;
76: */
77: commit;
78: