APPS.JTF_TASKS_PUB dependencies on JTF_TASK_RSC_REQS

Line 688: l_resource_req_id jtf_task_rsc_reqs.resource_req_id%TYPE;

684: l_task_id jtf_tasks_b.task_id%TYPE;
685: l_notes_id NUMBER;
686: l_dependency_id jtf_task_depends.dependency_id%TYPE;
687: l_recurrence_rule_id jtf_task_recur_rules.recurrence_rule_id%TYPE;
688: l_resource_req_id jtf_task_rsc_reqs.resource_req_id%TYPE;
689: l_task_rec jtf_task_recurrences_pub.task_details_rec;
690: l_reccurence_generated NUMBER;
691: /*** Start: Added a local variable to fix bug 2107464 ***/
692: l_task_contact_id jtf_task_contacts.task_contact_id%TYPE;

Line 6317: l_resource_req_id jtf_task_rsc_reqs.resource_req_id%TYPE;

6313: l_target_task_id jtf_tasks_b.task_id%TYPE := p_target_task_id;
6314: l_task_number jtf_tasks_b.task_id%TYPE := p_source_task_number;
6315: l_dependency_id jtf_task_depends.dependency_id%TYPE;
6316: l_task_assignment_id jtf_task_all_assignments.task_assignment_id%TYPE;
6317: l_resource_req_id jtf_task_rsc_reqs.resource_req_id%TYPE;
6318: l_task_reference_id jtf_task_references_b.task_reference_id%TYPE;
6319: l_task_date_id jtf_task_dates.task_date_id%TYPE;
6320: l_recurrence_rule_id jtf_task_recur_rules.recurrence_rule_id%TYPE;
6321: l_task_rec jtf_task_recurrences_pub.task_details_rec;

Line 6459: FROM jtf_task_rsc_reqs

6455: SELECT task_id
6456: , resource_type_code
6457: , required_units
6458: , enabled_flag
6459: FROM jtf_task_rsc_reqs
6460: WHERE task_id = l_source_task_id;
6461:
6462: CURSOR c_assignments IS
6463: SELECT resource_type_code