APPS.CS_AUTOGEN_TASK_PVT dependencies on JTF_TASK_TEMP_GROUPS_VL

Line 68: FROM jtf_task_temp_groups_vl

64: -- cursor to determine task template group name
65:
66: CURSOR c_get_tgt_name IS
67: SELECT template_group_name
68: FROM jtf_task_temp_groups_vl
69: WHERE task_template_group_id = l_task_template_group_info.task_template_group_id;
70:
71:
72: -- Simplex

Line 505: jtf_task_temp_groups_vl jtf

501: p_char VARCHAR2)
502: Is
503: Select gp.task_template_group_id
504: From cs_sr_tsk_tmpl_gp_map gp,
505: jtf_task_temp_groups_vl jtf
506: Where nvl(gp.incident_type_id, p_num) = nvl(p_incident_type_id, p_num)
507: And nvl(gp.organization_id, p_num) = nvl(p_organization_id, p_num)
508: And nvl(gp.inventory_item_id, p_num) = nvl(p_inventory_item_id, p_num)
509: And nvl(gp.category_id, p_num) = nvl(p_category_id, p_num)

Line 842: From Jtf_Task_Temp_Groups_vl

838:
839: Cursor c_get_task_tmpl_grp_info (p_task_template_group_id NUMBER)
840: Is
841: Select *
842: From Jtf_Task_Temp_Groups_vl
843: Where Task_Template_Group_Id = p_task_template_group_id;
844:
845: l_get_task_tmpl_grp_info_rec c_get_task_tmpl_grp_info%ROWTYPE;
846: