DBA Data[Home] [Help]

APPS.OZF_CLAIM_PVT dependencies on JTF_TASK_TEMP_GROUPS_VL

Line 2233: jtf_task_temp_groups_vl t

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'
2237: and t.task_template_group_id = r.task_template_group_id

Line 3398: jtf_task_temp_groups_vl t

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'
3402: and t.task_template_group_id = r.task_template_group_id

Line 6760: FROM jtf_task_temp_groups_vl t,

6756: -- Add cursor for matching actions and task.
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