APPS.JTF_TASKS_PUB dependencies on JTF_TASK_RECUR_RULES

Line 687: l_recurrence_rule_id jtf_task_recur_rules.recurrence_rule_id%TYPE;

683: l_msg_data VARCHAR2(2000); -- debug
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 ***/

Line 6295: l_recurrence_rule_id jtf_task_recur_rules.recurrence_rule_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;
6297: l_output_dates_counter NUMBER;
6298:
6299: CURSOR c_task IS

Line 6426: FROM jtf_task_recur_rules

6422: , occurs_every
6423: , occurs_number
6424: , start_date_active
6425: , end_date_active
6426: FROM jtf_task_recur_rules
6427: WHERE recurrence_rule_id = l_recurrence_rule_id;
6428:
6429: CURSOR c_rsc_reqs IS
6430: SELECT task_id