APPS.PO_DOCUMENT_CHECKS_PVT dependencies on PO_ELECTRONIC_DATA_ACCESS

Line 951: FROM po_electronic_data_access

947: l_complete_lookup VARCHAR2(100);
948:
949: CURSOR c_validate_pds_status IS
950: SELECT 'Y'
951: FROM po_electronic_data_access
952: WHERE doc_id = l_document_id
953: AND doc_type = l_doc_type
954: AND Nvl(draft_id,-1) = Nvl(l_draft_id,-1)
955: AND history_record = 'N'

Line 959: FROM po_electronic_data_access

955: AND history_record = 'N'
956: AND approved_without_check = 'Y'
957: UNION
958: SELECT 'Y'
959: FROM po_electronic_data_access
960: WHERE doc_id = l_document_id
961: AND doc_type = l_doc_type
962: AND Nvl(draft_id,-1) = Nvl(l_draft_id,-1)
963: AND history_record = 'Y'

Line 965: AND request_date = (SELECT Max(request_date) FROM po_electronic_data_access WHERE doc_id = l_document_id AND doc_type = l_doc_type AND Nvl(draft_id,-1) = Nvl(l_draft_id,-1) AND history_record = 'Y');

961: AND doc_type = l_doc_type
962: AND Nvl(draft_id,-1) = Nvl(l_draft_id,-1)
963: AND history_record = 'Y'
964: AND status = l_complete_lookup
965: AND request_date = (SELECT Max(request_date) FROM po_electronic_data_access WHERE doc_id = l_document_id AND doc_type = l_doc_type AND Nvl(draft_id,-1) = Nvl(l_draft_id,-1) AND history_record = 'Y');
966:
967: l_enable_eda VARCHAR2(1);
968:
969: CURSOR c_eda_status_lookup(cp_lookup_code VARCHAR2) IS