APPS.OZF_CLAIM_PVT dependencies on JTF_TASKS_B

Line 5262: FROM jtf_tasks_b jta, jtf_task_statuses_tl jtst

5258: /*
5259: SELECT jta.task_number,
5260: jtst.name task_status,
5261: substrb(jtf_task_utl.get_owner(jta.owner_type_code, jta.owner_id),1,239) owner_name
5262: FROM jtf_tasks_b jta, jtf_task_statuses_tl jtst
5263: WHERE jta.source_object_type_code = G_CLAIM_TYPE
5264: AND jta.source_object_id = p_id
5265: AND jtst.language = userenv('lang')
5266: AND jtst.task_status_id = jta.task_status_id;

Line 5271: FROM jtf_tasks_b jta, jtf_task_statuses_tl jtst

5267: */
5268: SELECT jta.task_number,
5269: jtst.name task_status,
5270: substrb(jtf_task_utl.get_owner(jta.owner_type_code, jta.owner_id),1,239) owner_name
5271: FROM jtf_tasks_b jta, jtf_task_statuses_tl jtst
5272: WHERE jta.source_object_type_code = G_OBJECT_TYPE
5273: AND jta.source_object_id = p_id
5274: AND jtst.language = userenv('lang')
5275: AND jtst.task_status_id = jta.task_status_id;

Line 5286: from jtf_tasks_b

5282: CURSOR task_count_csr(p_id in number)IS
5283: -- Bug#8718804 - Start
5284: /*
5285: select count(task_id)
5286: from jtf_tasks_b
5287: WHERE source_object_type_code = G_CLAIM_TYPE
5288: AND source_object_id = p_id;
5289: l_task_count number :=0;
5290: */

Line 5292: from jtf_tasks_b

5288: AND source_object_id = p_id;
5289: l_task_count number :=0;
5290: */
5291: select count(task_id)
5292: from jtf_tasks_b
5293: WHERE source_object_type_code = G_OBJECT_TYPE
5294: AND source_object_id = p_id;
5295: l_task_count number :=0;
5296:

Line 5522: FROM jtf_tasks_b

5518: CURSOR tasks_id_csr(p_id in number) IS
5519: -- Bug#8718804 - Start
5520: /*
5521: SELECT task_id, object_version_number
5522: FROM jtf_tasks_b
5523: WHERE source_object_type_code = G_CLAIM_TYPE
5524: AND source_object_id = p_id;
5525: */
5526: SELECT task_id, object_version_number

Line 5527: FROM jtf_tasks_b

5523: WHERE source_object_type_code = G_CLAIM_TYPE
5524: AND source_object_id = p_id;
5525: */
5526: SELECT task_id, object_version_number
5527: FROM jtf_tasks_b
5528: WHERE source_object_type_code = G_OBJECT_TYPE
5529: AND source_object_id = p_id;
5530: -- Bug#8718804 - End
5531:

Line 7944: update jtf_tasks_b

7940: END LOOP;
7941: END IF;
7942:
7943: /* --- Temp solution for updating the tasks
7944: update jtf_tasks_b
7945: set source_object_id =l_claim_history_id,
7946: source_object_type_code = G_CLAIM_HISTORY_TYPE,
7947: source_object_name = l_claim.claim_number
7948: where source_object_id = l_claim.claim_id