APPS.PA_TASK_ASSIGNMENT_UTILS dependencies on PA_PROJ_ELEMENTS

Line 241: FROM pa_proj_elements

237: AND ROWNUM = 1;
238:
239: CURSOR C_Get_Project_Id IS
240: SELECT project_id
241: FROM pa_proj_elements
242: WHERE proj_element_id = p_financial_task_id;
243:
244: l_project_id NUMBER := to_number(NULL);
245: L_FuncProc VARCHAR2(250) ;

Line 804: pa_proj_elements pe

800: SELECT pevs.scheduled_start_date, pevs.scheduled_finish_date,
801: pe.name task_name, pe.element_number task_number,
802: pe.proj_element_id
803: FROM pa_proj_elem_ver_schedule pevs, pa_proj_element_versions pev,
804: pa_proj_elements pe
805: WHERE pev.element_version_id = pevs.element_version_id
806: AND pev.element_version_id = p_elem_version_id
807: AND pev.proj_element_id = pe.proj_element_id;
808:

Line 1324: pa_proj_elements pe

1320: CURSOR C1_Task_Dates(p_elem_version_id IN NUMBER) IS
1321: SELECT pevs.scheduled_start_date, pevs.scheduled_finish_date,
1322: pe.name task_name, pe.element_number task_number
1323: FROM pa_proj_elem_ver_schedule pevs, pa_proj_element_versions pev,
1324: pa_proj_elements pe
1325: WHERE pev.element_version_id = pevs.element_version_id
1326: AND pev.element_version_id = p_elem_version_id
1327: AND pev.proj_element_id = pe.proj_element_id;
1328:

Line 2311: FROM pa_proj_element_versions pev, pa_proj_elements pe

2307: L_FuncProc varchar2(250) ;
2308:
2309: CURSOR C_Element_Info(p_wbs_element_version_id IN NUMBER) IS
2310: SELECT pev.project_id, pev.parent_structure_version_id, pev.proj_element_id, pe.name, pe.element_number
2311: FROM pa_proj_element_versions pev, pa_proj_elements pe
2312: WHERE pev.element_version_id = p_wbs_element_version_id AND pe.proj_element_id = pev.proj_element_id;
2313:
2314: CURSOR C_Element_Info2(p_resource_assignment_id IN NUMBER) IS
2315: SELECT ra.wbs_element_version_id, ra.project_id, pev.proj_element_id, ra.resource_list_member_id, ra.ta_display_flag, ra.task_id, ra.unplanned_flag, ra.total_plan_quantity

Line 5030: L_Status := pa_proj_elements_utils.check_edit_task_ok(

5026: L_Project_Id := p_project_id;
5027:
5028: END IF;
5029:
5030: L_Status := pa_proj_elements_utils.check_edit_task_ok(
5031: P_PROJECT_ID => l_project_id,
5032: P_STRUCTURE_VERSION_ID => l_structure_version_id,
5033: P_CURR_STRUCT_VERSION_ID => l_structure_version_id,
5034: p_require_lock_flag => 'N',