DBA Data[Home] [Help]

APPS.JTF_TASK_UTL dependencies on JTF_TASK_TEMPLATES_B

Line 945: FROM jtf_task_templates_b

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);
947:
948: l_task_template_group_id jtf_task_temp_groups_b.task_template_group_id%TYPE;
949: BEGIN

Line 1042: FROM jtf_task_templates_b

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
1045: x_return_status := fnd_api.g_ret_sts_success;
1046:

Line 1574: FROM jtf_task_templates_b

1570: IS
1571: CURSOR c_task_id
1572: IS
1573: SELECT task_template_id task_id
1574: FROM jtf_task_templates_b
1575: WHERE task_template_id = p_task_id;
1576:
1577: CURSOR c_task_number
1578: IS

Line 1580: FROM jtf_task_templates_b

1576:
1577: CURSOR c_task_number
1578: IS
1579: SELECT task_template_id task_id
1580: FROM jtf_task_templates_b
1581: WHERE task_number = p_task_number;
1582:
1583: l_task_id jtf_tasks_b.task_id%TYPE;
1584: l_task_number jtf_tasks_b.task_number%TYPE;