APPS.POR_PURGE_SYS_SAVED_REQ dependencies on PO_REQUISITION_LINES_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 68: from PO_REQUISITION_LINES_ALL

64:
65: delete PO_REQ_DISTRIBUTIONS_ALL
66: where REQUISITION_LINE_ID in
67: ( select requisition_line_id
68: from PO_REQUISITION_LINES_ALL
69: where REQUISITION_HEADER_ID = syssaved_req_header_id);
70:
71: delete PO_REQUISITION_LINES_ALL
72: where REQUISITION_HEADER_ID = syssaved_req_header_id;

Line 71: delete PO_REQUISITION_LINES_ALL

67: ( select requisition_line_id
68: from PO_REQUISITION_LINES_ALL
69: where REQUISITION_HEADER_ID = syssaved_req_header_id);
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;