DBA Data[Home] [Help]

APPS.OKC_TERMS_UTIL_GRP dependencies on FND_ATTACHED_DOCUMENTS

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

3174:
3175: CURSOR contract_doc_csr IS
3176: SELECT tl.media_id ,
3177: docs.generated_flag
3178: FROM OKC_CONTRACT_DOCS docs, FND_ATTACHED_DOCUMENTS fnd,FND_DOCUMENTS_TL tl
3179: WHERE docs.primary_contract_doc_flag = 'Y'
3180: AND docs.business_document_version=-99
3181: AND docs.business_document_type = p_document_type
3182: AND docs.business_document_id = p_document_id

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

3214: --Bug 4131467 Added cursor to fetch attachment details from history table if document_version is passed
3215: CURSOR contract_doc_ver_csr IS
3216: SELECT tl.media_id ,
3217: docs.generated_flag
3218: FROM OKC_CONTRACT_DOCS docs, FND_ATTACHED_DOCUMENTS fnd,FND_DOCUMENTS_TL tl
3219: WHERE docs.primary_contract_doc_flag = 'Y'
3220: AND docs.business_document_version = p_document_version
3221: AND docs.business_document_type = p_document_type
3222: AND docs.business_document_id = p_document_id