DBA Data[Home] [Help]

APPS.CSM_LOBS_PKG dependencies on FND_DOCUMENTS

Line 105: fnd_documents fd

101: CURSOR l_max_seq_no_csr(p_task_assignment_id IN NUMBER, p_language IN VARCHAR2,p_category_name IN VARCHAR2,c_entity_name IN VARCHAR2)
102: IS
103: SELECT nvl(max(fad.seq_num),0)+10
104: FROM fnd_attached_documents fad,
105: fnd_documents fd
106: WHERE fad.pk1_value = to_char(p_task_assignment_id)
107: AND fd.document_id = fad.document_id
108: AND fad.entity_name = c_entity_name
109: AND EXISTS