APPS.PA_FIN_PLAN_PVT dependencies on PA_TASKS

Line 931: from pa_tasks t ,pa_resource_assignments r

927:
928: for bl_rec in (select start_date,
929: completion_date ,
930: resource_assignment_id
931: from pa_tasks t ,pa_resource_assignments r
932: where t.task_id = r.task_id and
933: r.budget_version_id = l_target_version_id)
934: loop
935: bl_rec.start_date := nvl(bl_rec.start_date,v_project_start_date);

Line 2136: ,p_impacted_task_id IN pa_tasks.task_id%TYPE --:= NULL

2132: ,p_est_proj_bd_cost IN pa_budget_versions.est_project_burdened_cost%TYPE--:= NULL
2133: ,p_est_proj_revenue IN pa_budget_versions.est_project_revenue%TYPE --:= NULL
2134: ,p_est_qty IN pa_budget_versions.est_quantity%TYPE --:= NULL
2135: ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE --FP.M
2136: ,p_impacted_task_id IN pa_tasks.task_id%TYPE --:= NULL
2137: ,p_agreement_id IN pa_budget_versions.agreement_id%TYPE --:= NULL
2138: -- End of additional columns for Bug :- 2634900
2139: -- Added the two flags below as part of changes to AMG for finplan model
2140: ,p_create_new_curr_working_flag IN VARCHAR2

Line 2156: CURSOR impacted_task_cur(c_impacted_task_id pa_tasks.task_id%TYPE) IS

2152: l_msg_index_out NUMBER;
2153: l_return_status VARCHAR2(1);
2154: l_debug_mode VARCHAR2(30);
2155:
2156: CURSOR impacted_task_cur(c_impacted_task_id pa_tasks.task_id%TYPE) IS
2157: SELECT pt.parent_task_id parent_task_id,
2158: pt.top_task_id top_task_id ,
2159: pelm.element_Version_id element_Version_id
2160: FROM pa_tasks pt,

Line 2160: FROM pa_tasks pt,

2156: CURSOR impacted_task_cur(c_impacted_task_id pa_tasks.task_id%TYPE) IS
2157: SELECT pt.parent_task_id parent_task_id,
2158: pt.top_task_id top_task_id ,
2159: pelm.element_Version_id element_Version_id
2160: FROM pa_tasks pt,
2161: pa_proj_element_versions pelm
2162: WHERE pt.task_id = c_impacted_task_id
2163: AND pelm.proj_element_id=pt.task_id
2164: AND pelm.parent_structure_version_id=PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID( p_project_id);