APPS.OZF_CLAIM_PVT dependencies on OZF_REASONS

Line 2564: from ozf_reasons r,

2560: return number
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'

Line 3778: from ozf_reasons r,

3774: l_retcode VARCHAR2(30);
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'

Line 8414: ozf_reasons r

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
8418: AND NVL(t.start_date_active, SYSDATE) <= SYSDATE