APPS.CS_KB_CTX_PKG dependencies on FND_ATTACHED_DOCUMENTS

Line 575: FROM fnd_attached_documents fad,

571: CONNECT BY PRIOR parent_category_id = category_id;
572: -- Changed the cursor to fix 11739796
573: CURSOR c8(c_setid IN NUMBER, c_lang IN VARCHAR2) IS
574: SELECT fdtl.title, fdtl.description, fl.file_name, fad.document_id
575: FROM fnd_attached_documents fad,
576: fnd_documents fd,
577: fnd_documents_tl fdtl,
578: fnd_lobs fl
579: WHERE fad.document_id = fd.document_id

Line 1061: FROM fnd_attached_documents fad,

1057: p_temp_clob IN OUT NOCOPY CLOB)
1058: IS
1059: /* CURSOR c1(c_setid IN NUMBER, c_lang IN VARCHAR2) IS
1060: SELECT fdtl.title, fdtl.description, fl.file_name, fl.file_data
1061: FROM fnd_attached_documents fad,
1062: fnd_documents fd,
1063: fnd_documents_tl fdtl,
1064: fnd_lobs fl
1065: WHERE fad.document_id = fd.document_id

Line 1074: FROM fnd_attached_documents fad,

1070: AND fad.pk1_value = c_setid; */
1071: -- Changed the cursor for bug 8815880,11739796
1072: CURSOR c1(c_setid IN NUMBER, c_lang IN VARCHAR2) IS
1073: SELECT fdtl.title, fdtl.description, fl.file_name, fd.url, fst.short_text
1074: FROM fnd_attached_documents fad,
1075: fnd_documents fd,
1076: fnd_documents_tl fdtl,
1077: fnd_lobs fl,
1078: fnd_documents_short_text fst

Line 1171: FROM fnd_attached_documents fad,

1167: from CS_KB_SET_ELES se
1168: where se.set_id = c_setid;
1169: */
1170: SELECT fad.document_id
1171: FROM fnd_attached_documents fad,
1172: fnd_documents fd
1173: WHERE fad.document_id = fd.document_id
1174: AND fad.entity_name = 'CS_KB_SETS_B'
1175: AND fad.pk1_value = c_setid;