DBA Data[Home] [Help]

APPS.JTF_TASK_UTL dependencies on JTF_TASK_STATUSES_B

Line 1822: FROM jtf_task_statuses_b

1818: IS
1819: CURSOR c_task_status_id
1820: IS
1821: SELECT task_status_id
1822: FROM jtf_task_statuses_b
1823: WHERE task_status_id = p_task_status_id
1824: AND trunc(NVL (end_date_active, SYSDATE)) >= trunc(SYSDATE)
1825: AND trunc(NVL (start_date_active, SYSDATE)) <= trunc(SYSDATE);
1826:

Line 3739: FROM jtf_task_statuses_b

3735: x_return_status := fnd_api.g_ret_sts_unexp_error;
3736:
3737: SELECT task_status_id, task_status_flag, assignment_status_flag, usage
3738: INTO l_status_id, l_task_status_flag, l_assignment_status_flag, l_usage
3739: FROM jtf_task_statuses_b
3740: WHERE task_status_id = p_status_id;
3741:
3742: IF SQL%FOUND THEN
3743: IF p_type = 'TASK' AND l_task_status_flag = jtf_task_utl.g_yes_char