APPS.OZF_CLAIM_PVT dependencies on OZF_REASONS

Line 2232: from ozf_reasons r,

2228: return number
2229: IS
2230: CURSOR default_action_id_csr (p_id in number) is
2231: select t.task_template_group_id
2232: from ozf_reasons r,
2233: jtf_task_temp_groups_vl t
2234: where t.source_object_type_code = 'AMS_CLAM'
2235: and r.active_flag = 'T'
2236: and r.default_flag = 'T'

Line 3397: from ozf_reasons r,

3393: l_retcode VARCHAR2(30);
3394:
3395: CURSOR default_action_id_csr (p_id in number) is
3396: select t.task_template_group_id
3397: from ozf_reasons r,
3398: jtf_task_temp_groups_vl t
3399: where t.source_object_type_code = 'OZF_CLAM'
3400: and r.active_flag = 'T'
3401: and r.default_flag = 'T'

Line 6761: ozf_reasons r

6757: CURSOR action_count_csr(p_reason_code_id in number,
6758: p_task_template_id in number) IS
6759: SELECT count(t.task_template_group_id)
6760: FROM jtf_task_temp_groups_vl t,
6761: ozf_reasons r
6762: WHERE t.source_object_type_code = 'OZF_CLAM'
6763: AND r.active_flag = 'T'
6764: AND t.task_template_group_id = r.task_template_group_id
6765: AND NVL(t.start_date_active, SYSDATE) <= SYSDATE