DBA Data[Home] [Help]

APPS.OZF_CLAIM_PVT dependencies on JTF_TASK_STATUSES_VL

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