DBA Data[Home] [Help]

APPS.PER_NL_WAZO_ARCHIVE dependencies on FND_DOCUMENTS

Line 2074: ,fnd_documents fd

2070: /**************************************************************************/
2071: CURSOR cur_addl_sick_info(p_abs_attendance_id IN NUMBER) IS
2072: SELECT fdst.short_text text
2073: FROM fnd_attached_documents fad
2074: ,fnd_documents fd
2075: ,fnd_document_categories fdc
2076: ,fnd_document_datatypes fdd
2077: ,fnd_documents_short_text fdst
2078: WHERE fad.entity_name = 'PER_ABSENCE_ATTENDANCES'

Line 2077: ,fnd_documents_short_text fdst

2073: FROM fnd_attached_documents fad
2074: ,fnd_documents fd
2075: ,fnd_document_categories fdc
2076: ,fnd_document_datatypes fdd
2077: ,fnd_documents_short_text fdst
2078: WHERE fad.entity_name = 'PER_ABSENCE_ATTENDANCES'
2079: AND fad.pk1_value = to_char (p_abs_attendance_id)
2080: AND fd.document_id = fad.document_id
2081: AND fdd.datatype_id = fd.datatype_id