APPS.PA_WORKPLAN_ATTR_UTILS dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 32: FROM pa_proj_elements pe, pa_proj_element_versions pev,

28: if (p_lifecycle_id = FND_API.G_MISS_NUM) OR (p_lifecycle_id is NULL) then
29: if (p_lifecycle_name is not NULL) then
30: SELECT pev.element_version_id
31: INTO x_lifecycle_id
32: FROM pa_proj_elements pe, pa_proj_element_versions pev,
33: pa_lifecycle_usages plu
34: WHERE pe.project_id=0
35: AND pe.proj_element_id = pev.proj_element_id
36: AND pe.element_number = p_lifecycle_name

Line 53: FROM pa_proj_elements pe, pa_proj_element_versions pev,

49: x_lifecycle_id := NULL;
50: ELSE
51: SELECT pev.element_version_id
52: INTO x_lifecycle_id
53: FROM pa_proj_elements pe, pa_proj_element_versions pev,
54: pa_lifecycle_usages plu
55: WHERE pe.project_id=0
56: AND pe.proj_element_id = pev.proj_element_id
57: AND pe.element_number = p_lifecycle_name

Line 109: FROM pa_proj_elements pe, pa_proj_element_versions pev

105: if (p_current_lifecycle_phase_id = FND_API.G_MISS_NUM) OR (p_current_lifecycle_phase_id is NULL) then
106: if (p_current_lifecycle_phase is not NULL) then
107: SELECT pev.element_version_id
108: INTO x_current_lifecycle_phase_id
109: FROM pa_proj_elements pe, pa_proj_element_versions pev
110: WHERE pe.project_id=0
111: AND pe.element_number = p_current_lifecycle_phase
112: AND pe.proj_element_id = pev.proj_element_id
113: AND pev.parent_structure_version_id = p_lifecycle_id;

Line 128: FROM pa_proj_elements pe, pa_proj_element_versions pev

124: x_current_lifecycle_phase_id := NULL;
125: ELSE
126: SELECT pev.element_version_id
127: INTO x_current_lifecycle_phase_id
128: FROM pa_proj_elements pe, pa_proj_element_versions pev
129: WHERE pe.project_id=0
130: AND pe.element_number = p_current_lifecycle_phase
131: AND pe.proj_element_id = pev.proj_element_id
132: AND pev.parent_structure_version_id = p_lifecycle_id;

Line 403: FROM pa_proj_element_versions

399: IS
400:
401: CURSOR get_lifecycle_version(c_proj_element_id IN NUMBER) IS
402: SELECT element_version_id
403: FROM pa_proj_element_versions
404: WHERE proj_element_id = c_proj_element_id;
405: cur_lifecycle_version get_lifecycle_version%ROWTYPE;
406:
407: CURSOR c1(c_lifecycle_version_id IN NUMBER) IS

Line 474: FROM pa_proj_element_versions

470: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
471: IS
472: CURSOR get_phase_version(c_proj_element_id IN NUMBER) IS
473: SELECT element_version_id
474: FROM pa_proj_element_versions
475: WHERE proj_element_id = c_proj_element_id;
476: cur_phase_version get_phase_version%ROWTYPE;
477:
478: CURSOR c1(c_phase_version_id IN NUMBER) IS