DBA Data[Home] [Help]

APPS.CSM_DEBRIEF_LABOR_PKG dependencies on JTF_TASK_STATUSES_B

Line 64: jtf_task_statuses_b tst

60: ) IS
61: SELECT tst.rejected_flag, tst.on_hold_flag, tst.cancelled_flag,
62: tst.closed_flag, tst.completed_flag
63: FROM csf_debrief_headers dh, jtf_task_assignments tas,
64: jtf_task_statuses_b tst
65: WHERE dh.task_assignment_id = tas.task_assignment_id
66: AND tas.assignment_status_id = tst.task_status_id
67: AND dh.debrief_header_id = p_debrief_header_id;
68: