[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: