APPS.PA_TASK_ASSIGNMENTS_PUB dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 1426: from pa_proj_element_versions pe

1422: CURSOR C_Task_Elem_Version_Id(p_structure_version_id IN NUMBER,
1423: p_task_id in NUMBER,
1424: p_project_id IN NUMBER) IS
1425: SELECT pe.element_version_id
1426: from pa_proj_element_versions pe
1427: where parent_structure_version_id = p_structure_version_id
1428: and pe.proj_element_id = p_task_id
1429: and pe.project_id = p_project_id;
1430:

Line 1433: from pa_proj_element_versions pe

1429: and pe.project_id = p_project_id;
1430:
1431: CURSOR C_task_version(p_task_element_version_id IN NUMBER) IS
1432: SELECT pe.element_version_id, pe.proj_element_id
1433: from pa_proj_element_versions pe
1434: where pe.element_version_id = p_task_element_version_id;
1435:
1436:
1437: CURSOR c_cur_out(p_structure_version_id IN NUMBER,

Line 3738: from pa_proj_element_versions pe

3734: CURSOR C_Task_Elem_Version_Id(p_structure_version_id IN NUMBER,
3735: p_task_id in NUMBER,
3736: p_project_id IN NUMBER) IS
3737: SELECT pe.element_version_id
3738: from pa_proj_element_versions pe
3739: where parent_structure_version_id = p_structure_version_id
3740: and pe.proj_element_id = p_task_id
3741: and pe.project_id = p_project_id;
3742:

Line 3745: from pa_proj_element_versions pe

3741: and pe.project_id = p_project_id;
3742:
3743: CURSOR C_task_version(p_task_element_version_id IN NUMBER) IS
3744: SELECT pe.element_version_id, pe.proj_element_id
3745: from pa_proj_element_versions pe
3746: where pe.element_version_id = p_task_element_version_id;
3747:
3748: c_index NUMBER := 0;
3749: u_index NUMBER := 0;

Line 6401: from pa_proj_element_versions c,

6397:
6398: -- Bug 3872176 Cursor to get the structure_version_id of a template
6399: CURSOR get_template_struct_ver IS
6400: select c.element_version_id
6401: from pa_proj_element_versions c,
6402: pa_proj_elements b,
6403: pa_proj_structure_types a,
6404: pa_structure_types d
6405: where d.structure_type_class_code = 'WORKPLAN'