DBA Data[Home] [Help]

APPS.CSM_LOBS_PKG dependencies on FND_ATTACHED_DOCUMENTS

Line 104: FROM fnd_attached_documents fad,

100: -- get max seq no for the debrief_header_id
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