DBA Data[Home] [Help]

APPS.CSM_TASK_ASSIGNMENTS_PKG dependencies on JTF_TASK_STATUSES_B

Line 572: FROM jtf_task_statuses_b

568: IS
569: CURSOR c_new_status_closed(b_task_status_id NUMBER)
570: IS
571: SELECT closed_flag
572: FROM jtf_task_statuses_b
573: WHERE task_status_id=b_task_status_id;
574: l_is_closed VARCHAR2(100):='N';
575: BEGIN
576:

Line 670: jtf_task_statuses_b tst

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;
674: