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 6292: l_resource_req_id jtf_task_rsc_reqs.resource_req_id%TYPE;

6288: l_target_task_id jtf_tasks_b.task_id%TYPE := p_target_task_id;
6289: l_task_number jtf_tasks_b.task_id%TYPE := p_source_task_number;
6290: l_dependency_id jtf_task_depends.dependency_id%TYPE;
6291: l_task_assignment_id jtf_task_all_assignments.task_assignment_id%TYPE;
6292: l_resource_req_id jtf_task_rsc_reqs.resource_req_id%TYPE;
6293: l_task_reference_id jtf_task_references_b.task_reference_id%TYPE;
6294: l_task_date_id jtf_task_dates.task_date_id%TYPE;
6295: l_recurrence_rule_id jtf_task_recur_rules.recurrence_rule_id%TYPE;
6296: l_task_rec jtf_task_recurrences_pub.task_details_rec;

Line 6434: FROM jtf_task_rsc_reqs

6430: SELECT task_id
6431: , resource_type_code
6432: , required_units
6433: , enabled_flag
6434: FROM jtf_task_rsc_reqs
6435: WHERE task_id = l_source_task_id;
6436:
6437: CURSOR c_assignments IS
6438: SELECT resource_type_code