APPS.OZF_CLAIM_PVT dependencies on JTF_TASKS_B

Line 4415: FROM jtf_tasks_b jta, jtf_task_statuses_tl jtst

4411: CURSOR tasks_info_csr(p_id in number) IS
4412: SELECT jta.task_number,
4413: jtst.name task_status,
4414: substrb(jtf_task_utl.get_owner(jta.owner_type_code, jta.owner_id),1,239) owner_name
4415: FROM jtf_tasks_b jta, jtf_task_statuses_tl jtst
4416: WHERE jta.source_object_type_code = G_CLAIM_TYPE
4417: AND jta.source_object_id = p_id
4418: AND jtst.language = userenv('lang')
4419: AND jtst.task_status_id = jta.task_status_id;

Line 4426: from jtf_tasks_b

4422: l_tasks_info_tbl tasks_info_tbl_type;
4423:
4424: CURSOR task_count_csr(p_id in number)IS
4425: select count(task_id)
4426: from jtf_tasks_b
4427: WHERE source_object_type_code = G_CLAIM_TYPE
4428: AND source_object_id = p_id;
4429: l_task_count number :=0;
4430:

Line 4652: FROM jtf_tasks_b

4648: l_ind number :=1;
4649:
4650: CURSOR tasks_id_csr(p_id in number) IS
4651: SELECT task_id, object_version_number
4652: FROM jtf_tasks_b
4653: WHERE source_object_type_code = G_CLAIM_TYPE
4654: AND source_object_id = p_id;
4655:
4656: -- Fix for 5048675

Line 6493: update jtf_tasks_b

6489: END LOOP;
6490: END IF;
6491:
6492: /* --- Temp solution for updating the tasks
6493: update jtf_tasks_b
6494: set source_object_id =l_claim_history_id,
6495: source_object_type_code = G_CLAIM_HISTORY_TYPE,
6496: source_object_name = l_claim.claim_number
6497: where source_object_id = l_claim.claim_id