APPS.CSF_DEBRIEF_PVT dependencies on JTF_TASK_STATUSES_B

Line 1001: from jtf_task_statuses_b jtsb,

997: select greatest(nvl(rejected_flag,'N'),
998: nvl(completed_flag,'N'),
999: nvl(closed_flag,'N'),
1000: nvl(cancelled_flag,'N'))
1001: from jtf_task_statuses_b jtsb,
1002: jtf_task_assignments jta,
1003: csf_debrief_headers cdh
1004: where cdh.debrief_header_id = p_debrief_header_id
1005: and jta.task_assignment_id = cdh.task_assignment_id

Line 1816: from jtf_task_statuses_b jtsb,

1812: select greatest(nvl(rejected_flag,'N'),
1813: nvl(completed_flag,'N'),
1814: nvl(closed_flag,'N'),
1815: nvl(cancelled_flag,'N'))
1816: from jtf_task_statuses_b jtsb,
1817: jtf_task_assignments jta,
1818: csf_debrief_headers cdh
1819: where cdh.debrief_header_id = p_debrief_header_id
1820: and jta.task_assignment_id = cdh.task_assignment_id