APPS.OZF_CLAIM_PVT dependencies on JTF_TASKS_VL

Line 1378: FROM jtf_tasks_vl

1374: l_msg_count NUMBER;
1375:
1376: CURSOR task_status_csr (p_task_id in number) IS
1377: SELECT task_status_id
1378: FROM jtf_tasks_vl
1379: WHERE task_id = p_task_id;
1380:
1381: BEGIN
1382: -- Initialize API return status to sucess

Line 5229: FROM jtf_tasks_vl a, jtf_task_statuses_vl b

5225:
5226: CURSOR tasks_csr(p_claim_id in number,
5227: p_completed_flag in varchar2) IS
5228: SELECT a.task_id, a.object_version_number
5229: FROM jtf_tasks_vl a, jtf_task_statuses_vl b
5230: WHERE b.completed_flag = p_completed_flag
5231: AND a.deleted_flag = 'N'
5232: AND a.task_status_id = b.task_status_id
5233: AND a.source_object_type_code = G_OBJECT_TYPE