563: IS
564: CURSOR c_task_template_group_id
565: IS
566: SELECT task_template_group_id
567: FROM jtf_task_temp_groups_b
568: WHERE task_template_group_id = p_task_template_group_id
569: AND trunc(NVL (end_date_active, SYSDATE)) >= trunc(SYSDATE)
570: AND trunc(NVL (start_date_active, SYSDATE)) <= trunc(SYSDATE);
571:
938: IS
939: CURSOR c_task_template_group
940: IS
941: SELECT task_template_group_id
942: FROM jtf_task_temp_groups_b
943: WHERE task_template_group_id =
944: (SELECT task_group_id
945: FROM jtf_task_templates_b
946: WHERE task_template_id = p_task_template_id);
944: (SELECT task_group_id
945: FROM jtf_task_templates_b
946: WHERE task_template_id = p_task_template_id);
947:
948: l_task_template_group_id jtf_task_temp_groups_b.task_template_group_id%TYPE;
949: BEGIN
950: OPEN c_task_template_group;
951: FETCH c_task_template_group INTO l_task_template_group_id;
952:
1036:
1037: CURSOR c_template_object_details
1038: IS
1039: SELECT source_object_type_code
1040: FROM jtf_task_temp_groups_b
1041: WHERE task_template_group_id = (SELECT task_group_id
1042: FROM jtf_task_templates_b
1043: WHERE task_template_id = p_task_id);
1044: BEGIN