APPS.CS_AUTOGEN_TASK_PVT dependencies on JTF_TASK_TEMP_GROUPS_VL

Line 136: FROM jtf_task_temp_groups_vl

132: -- cursor to determine task template group name
133:
134: CURSOR c_get_tgt_name IS
135: SELECT template_group_name
136: FROM jtf_task_temp_groups_vl
137: WHERE task_template_group_id = l_task_template_group_info.task_template_group_id;
138:
139:
140: -- Simplex

Line 583: jtf_task_temp_groups_vl jtf

579: p_char VARCHAR2)
580: Is
581: Select gp.task_template_group_id
582: From cs_sr_tsk_tmpl_gp_map gp,
583: jtf_task_temp_groups_vl jtf
584: Where nvl(gp.incident_type_id, p_num) = nvl(p_incident_type_id, p_num)
585: And nvl(gp.organization_id, p_num) = nvl(p_organization_id, p_num)
586: And nvl(gp.inventory_item_id, p_num) = nvl(p_inventory_item_id, p_num)
587: And nvl(gp.category_id, p_num) = nvl(p_category_id, p_num)

Line 923: From Jtf_Task_Temp_Groups_vl

919:
920: Cursor c_get_task_tmpl_grp_info (p_task_template_group_id NUMBER)
921: Is
922: Select *
923: From Jtf_Task_Temp_Groups_vl
924: Where Task_Template_Group_Id = p_task_template_group_id;
925:
926: l_get_task_tmpl_grp_info_rec c_get_task_tmpl_grp_info%ROWTYPE;
927: