DBA Data[Home] [Help]

APPS.OZF_CLAIM_PVT dependencies on JTF_TASK_TEMP_GROUPS_VL

Line 2565: jtf_task_temp_groups_vl t

2561: IS
2562: CURSOR default_action_id_csr (p_id in number) is
2563: select t.task_template_group_id
2564: from ozf_reasons r,
2565: jtf_task_temp_groups_vl t
2566: where t.source_object_type_code = 'AMS_CLAM'
2567: and r.active_flag = 'T'
2568: and r.default_flag = 'T'
2569: and t.task_template_group_id = r.task_template_group_id

Line 3779: jtf_task_temp_groups_vl t

3775:
3776: CURSOR default_action_id_csr (p_id in number) is
3777: select t.task_template_group_id
3778: from ozf_reasons r,
3779: jtf_task_temp_groups_vl t
3780: where t.source_object_type_code = 'OZF_CLAM'
3781: and r.active_flag = 'T'
3782: and r.default_flag = 'T'
3783: and t.task_template_group_id = r.task_template_group_id

Line 8413: FROM jtf_task_temp_groups_vl t,

8409: -- Add cursor for matching actions and task.
8410: CURSOR action_count_csr(p_reason_code_id in number,
8411: p_task_template_id in number) IS
8412: SELECT count(t.task_template_group_id)
8413: FROM jtf_task_temp_groups_vl t,
8414: ozf_reasons r
8415: WHERE t.source_object_type_code = 'OZF_CLAM'
8416: AND r.active_flag = 'T'
8417: AND t.task_template_group_id = r.task_template_group_id