DBA Data[Home] [Help]

APPS.OZF_CLAIM_PVT dependencies on JTF_TASK_STATUSES_TL

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;