DBA Data[Home] [Help]

APPS.CSM_TASK_ASSIGNMENTS_PKG dependencies on CSF_DEBRIEF_HEADERS

Line 669: FROM csf_debrief_headers dh, jtf_task_assignments tas,

665: CURSOR c_chk_task_status( p_task_assignment_id NUMBER)
666: IS
667: SELECT dh.debrief_header_id, tst.rejected_flag, tst.on_hold_flag,
668: tst.cancelled_flag, tst.closed_flag, tst.completed_flag
669: FROM csf_debrief_headers dh, jtf_task_assignments tas,
670: jtf_task_statuses_b tst
671: WHERE dh.task_assignment_id = tas.task_assignment_id
672: AND tas.assignment_status_id = tst.task_status_id
673: AND tas.task_assignment_id = p_task_assignment_id;