[Home] [Help]
APPS.CSM_MULTI_MOBQRY_PKG dependencies on CSF_DEBRIEF_HEADERS
Line 1895: FROM jtf_task_assignments tas, csf_debrief_headers dh,
1891: CURSOR c_chk_task_status ( p_task_assignment_id NUMBER ) IS
1892: SELECT dh.debrief_header_id, tst.rejected_flag,
1893: tst.on_hold_flag, tst.cancelled_flag,
1894: tst.closed_flag, tst.completed_flag
1895: FROM jtf_task_assignments tas, csf_debrief_headers dh,
1896: jtf_task_statuses_b tst
1897: WHERE tas.task_assignment_id = p_task_assignment_id
1898: AND tas.task_assignment_id = dh.task_assignment_id
1899: AND tas.assignment_status_id = tst.task_status_id;