eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FP_WEBADI_UTILS dependencies on PA_TASKS

Line 407: pa_tasks pt

403: CURSOR C1(l_budget_version_id number) IS
404: SELECT pt.start_date,pt.completion_date
405: FROM pa_resource_assignments pra,
406: pa_budget_versions pbv,
407: pa_tasks pt
408: WHERE pra.budget_version_id = pbv.budget_version_id
409: AND pbv.budget_version_id = l_budget_version_id
410: AND pt.task_id = pra.task_id
411: AND pra.project_id = pbv.project_id

Line 523: from pa_tasks

519: BEGIN
520:
521: select task_id
522: into x_task_id
523: from pa_tasks
524: where project_id = p_project_id
525: and task_number = p_task_num;
526:
527: EXCEPTION

Line 736: ,x_task_number OUT NOCOPY pa_tasks.task_number%TYPE --File.Sql.39 bug 4440895

732:
733: PROCEDURE GET_RES_ASSIGNMENT_INFO
734: (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE
735: ,p_planning_level IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
736: ,x_task_number OUT NOCOPY pa_tasks.task_number%TYPE --File.Sql.39 bug 4440895
737: ,x_task_id OUT NOCOPY pa_tasks.task_id%TYPE --File.Sql.39 bug 4440895
738: ,x_resource_alias OUT NOCOPY pa_resource_list_members.alias%TYPE --File.Sql.39 bug 4440895
739: ,x_resource_group_alias OUT NOCOPY pa_resource_list_members.alias%TYPE --File.Sql.39 bug 4440895
740: ,x_parent_assignment_id OUT NOCOPY pa_resource_assignments.parent_assignment_id%TYPE --File.Sql.39 bug 4440895

Line 737: ,x_task_id OUT NOCOPY pa_tasks.task_id%TYPE --File.Sql.39 bug 4440895

733: PROCEDURE GET_RES_ASSIGNMENT_INFO
734: (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE
735: ,p_planning_level IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
736: ,x_task_number OUT NOCOPY pa_tasks.task_number%TYPE --File.Sql.39 bug 4440895
737: ,x_task_id OUT NOCOPY pa_tasks.task_id%TYPE --File.Sql.39 bug 4440895
738: ,x_resource_alias OUT NOCOPY pa_resource_list_members.alias%TYPE --File.Sql.39 bug 4440895
739: ,x_resource_group_alias OUT NOCOPY pa_resource_list_members.alias%TYPE --File.Sql.39 bug 4440895
740: ,x_parent_assignment_id OUT NOCOPY pa_resource_assignments.parent_assignment_id%TYPE --File.Sql.39 bug 4440895
741: ,x_resource_list_member_id OUT NOCOPY pa_resource_list_members.resource_list_member_id%TYPE --File.Sql.39 bug 4440895

Line 771: FROM pa_tasks pt

767: ,pra.unit_of_measure
768: ,pra.parent_assignment_id
769: ,prlm.resource_list_member_id
770: ,prlm.resource_id
771: FROM pa_tasks pt
772: ,pa_resource_assignments pra
773: ,pa_resource_list_members prlm
774: ,pa_resource_list_members prlm_parent
775: ,pa_resource_lists_all_bg prl