APPS.AMS_COPYELEMENTS_PVT dependencies on FND_DOCUMENTS

Line 1041: FROM fnd_documents b, fnd_documents_tl tl

1037: SELECT b.datatype_id ,b.category_id ,b.security_type ,
1038: b.publish_flag ,tl.description ,b.file_name ,
1039: b.media_id ,tl.doc_attribute2 ,tl.language,tl.short_text,
1040: DECODE(b.datatype_id,1,'TEXT',5,'URL',6,'FILE',3,'IMAGE') att_type
1041: FROM fnd_documents b, fnd_documents_tl tl
1042: WHERE b.document_id = tl.document_id
1043: AND tl.language = USERENV('LANG')
1044: AND b.document_id = l_doc_id ;
1045: l_doc_rec c_doc_det%ROWTYPE ;

Line 1050: from fnd_documents_short_text

1046:
1047: CURSOR c_short_txt (p_media_id IN NUMBER)
1048: IS
1049: select short_text
1050: from fnd_documents_short_text
1051: where media_id = p_media_id;
1052:
1053: l_short_text VARCHAR2(4000);
1054: