APPS.OZF_CLAIM_PVT dependencies on JTF_TASKS_VL

Line 1455: FROM jtf_tasks_vl

1451: l_msg_count NUMBER;
1452:
1453: CURSOR task_status_csr (p_task_id in number) IS
1454: SELECT task_status_id
1455: FROM jtf_tasks_vl
1456: WHERE task_id = p_task_id;
1457:
1458: BEGIN
1459: -- Initialize API return status to sucess

Line 6107: FROM jtf_tasks_vl a, jtf_task_statuses_vl b

6103:
6104: CURSOR tasks_csr(p_claim_id in number,
6105: p_completed_flag in varchar2) IS
6106: SELECT a.task_id, a.object_version_number
6107: FROM jtf_tasks_vl a, jtf_task_statuses_vl b
6108: WHERE b.completed_flag = p_completed_flag
6109: AND a.deleted_flag = 'N'
6110: AND a.task_status_id = b.task_status_id
6111: AND a.source_object_type_code = G_OBJECT_TYPE