APPS.JTF_EC_UTIL dependencies on JTF_EC_STATUSES_VL

Line 154: FROM jtf_ec_statuses_vl

150: l_api_name varchar2(61) := 'Validate_Esc_Status';
151:
152: cursor c_esc_status_id (p_esc_status_id NUMBER) Is
153: SELECT task_status_id
154: FROM jtf_ec_statuses_vl
155: WHERE task_status_id = p_esc_status_id
156: AND NVL (start_date_active, sysdate) <= sysdate
157: AND NVL (end_date_active, sysdate) >= sysdate;
158:

Line 161: FROM jtf_ec_statuses_vl

157: AND NVL (end_date_active, sysdate) >= sysdate;
158:
159: cursor c_esc_status_name (p_esc_status_name VARCHAR2) Is
160: SELECT task_status_id
161: FROM jtf_ec_statuses_vl
162: WHERE name = p_esc_status_name
163: AND NVL (start_date_active, sysdate) <= sysdate
164: AND NVL (end_date_active, sysdate) >= sysdate;
165:

Line 314: jtf_ec_statuses_vl s

310: P_OBJECT_ID NUMBER) Is
311: Select r.task_reference_id
312: from jtf_tasks_b t,
313: jtf_task_references_b r,
314: jtf_ec_statuses_vl s
315: where r.reference_code = 'ESC'
316: and r.object_id = p_object_id
317: and r.object_type_code = p_object_type_code
318: and r.task_id = t.task_id

Line 330: jtf_ec_statuses_vl s

326: P_OBJECT_NAME VARCHAR2) Is
327: Select r.task_reference_id
328: from jtf_tasks_b t,
329: jtf_task_references_b r,
330: jtf_ec_statuses_vl s
331: where r.reference_code = 'ESC'
332: and r.object_name = p_object_name
333: and r.object_type_code = p_object_type_code
334: and t.task_type_id = 22

Line 640: from jtf_ec_statuses_vl

636: l_api_name varchar2(30) := 'Check_Completed_Status';
637:
638: cursor c_chk_completed (p_status_id NUMBER) is
639: select 'x'
640: from jtf_ec_statuses_vl
641: where task_status_id = p_status_id
642: and completed_flag = 'Y';
643:
644: