APPS.CSL_LOBS_PKG dependencies on FND_DOCUMENT_CATEGORIES_TL

Line 55: FROM fnd_document_categories_tl cat_tl

51: WHERE fad.pk1_value=to_char(p_debrief_header_id)
52: AND fd.document_id = fad.document_id
53: AND EXISTS
54: (SELECT 1
55: FROM fnd_document_categories_tl cat_tl
56: WHERE cat_tl.category_id = fd.category_id
57: AND cat_tl.user_name = 'Signature'
58: );
59:

Line 62: SELECT category_id FROM fnd_document_categories_tl

58: );
59:
60: -- get the category_id
61: CURSOR l_category_id_csr IS
62: SELECT category_id FROM fnd_document_categories_tl
63: WHERE user_name = 'Signature';
64:
65: l_dummy number;
66: -- to check if the record exists in the database