DBA Data[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;