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 6320: l_recurrence_rule_id jtf_task_recur_rules.recurrence_rule_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;
6322: l_output_dates_counter NUMBER;
6323:
6324: CURSOR c_task IS

Line 6451: FROM jtf_task_recur_rules

6447: , occurs_every
6448: , occurs_number
6449: , start_date_active
6450: , end_date_active
6451: FROM jtf_task_recur_rules
6452: WHERE recurrence_rule_id = l_recurrence_rule_id;
6453:
6454: CURSOR c_rsc_reqs IS
6455: SELECT task_id