DBA Data[Home] [Help]

APPS.CSM_LOBS_PKG dependencies on FND_DOCUMENT_CATEGORIES_TL

Line 111: FROM fnd_document_categories_tl cat_tl

107: AND fd.document_id = fad.document_id
108: AND fad.entity_name = c_entity_name
109: AND EXISTS
110: (SELECT 1
111: FROM fnd_document_categories_tl cat_tl
112: WHERE cat_tl.category_id = fd.category_id
113: AND cat_tl.name = p_category_name
114: AND cat_tl.LANGUAGE = p_language
115: );

Line 122: FROM fnd_document_categories_tl

118: -- get the category_id
119: CURSOR l_category_id_csr(p_language IN VARCHAR2, p_category_name IN VARCHAR2)
120: IS
121: SELECT category_id
122: FROM fnd_document_categories_tl
123: WHERE name = p_category_name
124: AND LANGUAGE = p_language;
125:
126: --to check if the record exists in the database