APPS.PA_TASK_MANAGER dependencies on PA_TASKS

Line 745: from pa_tasks t

741: and p.project_type = nvl(p_project_type, p.project_type);
742:
743: CURSOR c_seltaskmgrs (p_project_id IN NUMBER) IS
744: select distinct t.task_manager_person_id
745: from pa_tasks t
746: where t.project_id = p_project_id
747: and t.task_manager_person_id is not null;
748:
749: CURSOR c_task_end_date_active (p_project_id IN NUMBER,

Line 752: from pa_tasks t

748:
749: CURSOR c_task_end_date_active (p_project_id IN NUMBER,
750: p_task_manager_person_id IN NUMBER) IS
751: select 1
752: from pa_tasks t
753: where t.project_id = p_project_id
754: and t.task_manager_person_id = p_task_manager_person_id
755: and t.completion_date is NULL;
756:

Line 765: l_start_date pa_tasks.start_date%TYPE;

761: where project_id = p_project_id
762: and resource_source_id = p_task_manager_person_id
763: and project_role_id = p_project_role;
764:
765: l_start_date pa_tasks.start_date%TYPE;
766: l_dummy NUMBER;
767: l_dummy1 NUMBER;
768: l_mgr_start_date DATE;
769: l_mgr_end_date DATE;

Line 844: from pa_tasks t

840:
841: /* can be converted as a sub procedure, starts here */
842: select min(nvl(t.start_date,l_project_start_date)), max(completion_date)
843: into l_start_date_active, l_end_date_active
844: from pa_tasks t
845: where t.project_id = l_selprojs_rec.project_id
846: and t.task_manager_person_id = l_seltaskmgrs_rec.task_manager_person_id;
847:
848: open c_task_end_date_active(l_selprojs_rec.project_id,