DBA Data[Home] [Help]

APPS.CSFW_ATTACHMENT_PVT dependencies on FND_DOCUMENT_CATEGORIES_TL

Line 51: FROM fnd_document_categories_tl cat_tl

47: WHERE fad.pk1_value = to_char(x_incident_id)
48: AND fd.document_id = fad.document_id
49: AND EXISTS
50: (SELECT 1
51: FROM fnd_document_categories_tl cat_tl
52: WHERE cat_tl.category_id = fd.category_id
53: --AND cat_tl.user_name = p_category_user_name
54: );
55:

Line 60: FROM fnd_document_categories_tl

56: -- get the category_id
57: CURSOR l_category_id_cursor
58: IS
59: SELECT category_id
60: FROM fnd_document_categories_tl
61: WHERE user_name = p_category_user_name;
62:
63: -- get next sequence value for FND_LOBS
64: CURSOR l_fnd_lobs_s_cursor