DBA Data[Home] [Help]

APPS.PER_NL_DSR_ARCHIVE dependencies on FND_DOCUMENTS

Line 2511: ,fnd_documents fd

2507: /**************************************************************************/
2508: CURSOR cur_addl_sick_info(p_abs_attendance_id IN NUMBER) IS
2509: SELECT fdst.short_text text
2510: FROM fnd_attached_documents fad
2511: ,fnd_documents fd
2512: ,fnd_document_categories fdc
2513: ,fnd_document_datatypes fdd
2514: ,fnd_documents_short_text fdst
2515: WHERE fad.entity_name = 'PER_ABSENCE_ATTENDANCES'

Line 2514: ,fnd_documents_short_text fdst

2510: FROM fnd_attached_documents fad
2511: ,fnd_documents fd
2512: ,fnd_document_categories fdc
2513: ,fnd_document_datatypes fdd
2514: ,fnd_documents_short_text fdst
2515: WHERE fad.entity_name = 'PER_ABSENCE_ATTENDANCES'
2516: AND fad.pk1_value = to_char(p_abs_attendance_id)
2517: AND fd.document_id = fad.document_id
2518: AND fdd.datatype_id = fd.datatype_id