DBA Data[Home] [Help]

APPS.CSFW_SIGNATURE_PVT dependencies on FND_DOCUMENT_CATEGORIES_TL

Line 63: FROM fnd_document_categories_tl cat_tl

59: WHERE fad.pk1_value = to_char(x_debrief_header_id)
60: AND fd.document_id = fad.document_id
61: AND EXISTS
62: (SELECT 1
63: FROM fnd_document_categories_tl cat_tl
64: WHERE cat_tl.category_id = fd.category_id
65: AND cat_tl.user_name = 'Signature'
66: );
67:

Line 72: FROM fnd_document_categories_tl

68: -- get the category_id
69: CURSOR l_category_id_cursor
70: IS
71: SELECT category_id
72: FROM fnd_document_categories_tl
73: WHERE user_name = 'Signature';
74:
75: -- get next sequence value for FND_LOBS
76: CURSOR l_fnd_lobs_s_cursor