APPS.OKC_CONTRACT_DOCS_GRP dependencies on FND_DOCUMENTS_TL

Line 696: FROM fnd_documents B, fnd_documents_tl TL

692: TL.description description,
693: B.file_name file_name,
694: B.url url,
695: B.media_id media_id
696: FROM fnd_documents B, fnd_documents_tl TL
697: WHERE B.document_id = l_document_id
698: AND TL.document_id = l_document_id
699: AND TL.language = USERENV('LANG');
700:

Line 2686: -- Returns FND_DOCUMENTS_TL.media_id of the Primary contract file for the current version of the document if it is non mergeable.

2682: END IF;
2683: RETURN 'E';
2684: END Is_Primary_Terms_Doc_Mergeable;
2685:
2686: -- Returns FND_DOCUMENTS_TL.media_id of the Primary contract file for the current version of the document if it is non mergeable.
2687: -- 0 if document is mergeable.
2688: -- -1 if no primary document exists.
2689: FUNCTION Get_Primary_Terms_Doc_File_Id(
2690: p_document_type IN VARCHAR2,