DBA Data[Home] [Help]

APPS.OZF_CLAIM_PVT dependencies on JTF_TASK_UTL

Line 5261: substrb(jtf_task_utl.get_owner(jta.owner_type_code, jta.owner_id),1,239) owner_name

5257: -- Bug#8718804 - Start
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')

Line 5270: substrb(jtf_task_utl.get_owner(jta.owner_type_code, jta.owner_id),1,239) owner_name

5266: AND jtst.task_status_id = jta.task_status_id;
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')