DBA Data[Home] [Help]

APPS.CSFW_ATTACHMENT_PVT dependencies on FND_ATTACHED_DOCUMENTS

Line 45: FROM fnd_attached_documents fad,

41: -- get max document sequence number for the incident id
42: CURSOR l_max_seq_no_cursor(x_incident_id IN number)
43: IS
44: SELECT nvl(max(fad.seq_num),0)+10
45: FROM fnd_attached_documents fad,
46: fnd_documents fd
47: WHERE fad.pk1_value = to_char(x_incident_id)
48: AND fd.document_id = fad.document_id
49: AND EXISTS