APPS.JTF_TASK_UTL dependencies on JTF_TASK_STATUSES_VL

Line 1830: FROM jtf_task_statuses_vl

1826:
1827: CURSOR c_task_status_name
1828: IS
1829: SELECT task_status_id
1830: FROM jtf_task_statuses_vl
1831: WHERE name = p_task_status_name
1832: AND trunc(NVL (end_date_active, SYSDATE)) >= trunc(SYSDATE)
1833: AND trunc(NVL (start_date_active, SYSDATE)) <= trunc(SYSDATE);
1834:

Line 2913: FROM jtf_task_statuses_vl

2909: SELECT closed_flag, completed_flag, cancelled_flag,
2910: rejected_flag
2911: INTO l_closed_flag, l_completed_flag, l_cancelled_flag,
2912: l_rejected_flag
2913: FROM jtf_task_statuses_vl
2914: WHERE task_status_id = p_task_status_id;
2915:
2916: --- Added to check for rejected flag on 6th October.
2917: IF ( l_closed_flag IS NULL

Line 4690: FROM jtf_task_statuses_vl

4686: RETURN NULL;
4687: ELSE
4688: SELECT name
4689: INTO l_status_name
4690: FROM jtf_task_statuses_vl
4691: WHERE task_status_id = p_status_id;
4692: END IF;
4693:
4694: RETURN l_status_name;