DBA Data[Home] [Help]

APPS.CSM_TASK_ASSIGNMENTS_PKG dependencies on CSF_DEBRIEF_HEADERS

Line 412: FROM csf_debrief_headers dh, jtf_task_assignments tas,

408: )
409: IS
410: SELECT dh.debrief_header_id, tst.rejected_flag, tst.on_hold_flag,
411: tst.cancelled_flag, tst.closed_flag, tst.completed_flag
412: FROM csf_debrief_headers dh, jtf_task_assignments tas,
413: jtf_task_statuses_b tst
414: WHERE dh.task_assignment_id = tas.task_assignment_id
415: AND tas.assignment_status_id = tst.task_status_id
416: AND tas.task_assignment_id = p_task_assignment_id;