APPS.PO_EDA_IDX_FILE_GEN dependencies on PO_DRAFTS

Line 17: FROM po_headers_draft_all h, po_drafts d

13:
14:
15: CURSOR c_getmoddetails IS
16: SELECT h.po_header_id documentId, h.draft_id draftId
17: FROM po_headers_draft_all h, po_drafts d
18: WHERE d.modification_number = p_clm_document_number
19: AND d.document_id = h.po_header_id
20: AND d.draft_id = h.draft_id;
21:

Line 402: FROM po_drafts a)

398: WHERE uda_template_id IS NOT NULL
399: UNION
400: SELECT modification_number CLM_DOCUMENT_NUMBER, 'Y' ismod,MOD_EFFECTIVE_DATE effdate,(select APPROVED_DATE from po_headers_merge_v where
401: po_header_id = a.DOCUMENT_ID and draft_id = a.DRAFT_ID) APPROVED_DATE,CLM_EDAGEN_DATE
402: FROM po_drafts a)
403: WHERE (decode(P_IS_MOD,'Base Documents','N','Modifications','Y') = ismod or P_IS_MOD = 'Both')
404: AND
405: (
406: (l_approved_date is null and l_approved_date2 is null )

Line 833: UPDATE po_drafts SET CLM_EDAGEN_DATE = l_timestamp WHERE MODIFICATION_NUMBER = l_doc_number;

829: EXIT WHEN csr_req_stats%NOTFOUND;
830: IF(l_doc_type = 'N') THEN
831: UPDATE po_headers_all SET CLM_EDAGEN_DATE = l_timestamp WHERE CLM_DOCUMENT_NUMBER = l_doc_number;
832: ELSE
833: UPDATE po_drafts SET CLM_EDAGEN_DATE = l_timestamp WHERE MODIFICATION_NUMBER = l_doc_number;
834: END IF;
835: END LOOP;
836: CLOSE csr_req_stats;
837: