DBA Data[Home] [Help]

APPS.OKC_TERMS_UTIL_GRP dependencies on FND_ATTACHED_DOCUMENTS

Line 3288: FROM OKC_CONTRACT_DOCS docs, FND_ATTACHED_DOCUMENTS fnd,FND_DOCUMENTS_TL tl

3284:
3285: CURSOR contract_doc_csr IS
3286: SELECT tl.media_id ,
3287: docs.generated_flag
3288: FROM OKC_CONTRACT_DOCS docs, FND_ATTACHED_DOCUMENTS fnd,FND_DOCUMENTS_TL tl
3289: WHERE docs.primary_contract_doc_flag = 'Y'
3290: AND docs.business_document_version=-99
3291: AND docs.business_document_type = p_document_type
3292: AND docs.business_document_id = p_document_id

Line 3328: FROM OKC_CONTRACT_DOCS docs, FND_ATTACHED_DOCUMENTS fnd,FND_DOCUMENTS_TL tl

3324: --Bug 4131467 Added cursor to fetch attachment details from history table if document_version is passed
3325: CURSOR contract_doc_ver_csr IS
3326: SELECT tl.media_id ,
3327: docs.generated_flag
3328: FROM OKC_CONTRACT_DOCS docs, FND_ATTACHED_DOCUMENTS fnd,FND_DOCUMENTS_TL tl
3329: WHERE docs.primary_contract_doc_flag = 'Y'
3330: AND docs.business_document_version = p_document_version
3331: AND docs.business_document_type = p_document_type
3332: AND docs.business_document_id = p_document_id