APPS.CSFW_SIGNATURE_PVT dependencies on FND_DOCUMENT_CATEGORIES_TL

Line 57: FROM fnd_document_categories_tl cat_tl

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

Line 66: FROM fnd_document_categories_tl

62: -- get the category_id
63: CURSOR l_category_id_cursor
64: IS
65: SELECT category_id
66: FROM fnd_document_categories_tl
67: WHERE user_name = 'Signature';
68:
69: -- get next sequence value for FND_LOBS
70: CURSOR l_fnd_lobs_s_cursor