APPS.PA_PROJ_STRUCTURE_PVT dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 113: pa_proj_element_versions ppev,

109: --given source task id and destination project id.
110: CURSOR get_src_task_det(cp_src_task_id NUMBER) IS
111: SELECT ppev.element_version_id src_task_ver_id,ppe.project_id src_proj_id
112: FROM pa_proj_elements ppe,
113: pa_proj_element_versions ppev,
114: pa_tasks pt
115: WHERE ppe.proj_element_id = cp_src_task_id
116: AND ppe.project_id = ppev.project_id
117: AND ppe.proj_element_id = ppev.proj_element_id

Line 382: pa_proj_element_versions ppev,

378: --
379: CURSOR get_src_task_det(cp_src_task_id NUMBER) IS
380: SELECT ppev.element_version_id src_task_ver_id,ppe.project_id src_proj_id
381: FROM pa_proj_elements ppe,
382: pa_proj_element_versions ppev,
383: pa_tasks pt
384: WHERE ppe.proj_element_id = cp_src_task_id
385: AND ppe.project_id = ppev.project_id
386: AND ppe.proj_element_id = ppev.proj_element_id

Line 400: FROM pa_proj_element_versions ppev,

396: cp_src_proj_id NUMBER,
397: cp_dest_proj_id NUMBER) IS
398: SELECT porb.object_relationship_id lnk_obj_rel_id,
399: porb.record_version_number lnk_rel_rec_ver_number
400: FROM pa_proj_element_versions ppev,
401: pa_object_relationships pora,
402: pa_object_relationships porb,
403: pa_proj_elements ppe
404: WHERE pora.relationship_type = 'S'

Line 424: FROM pa_proj_element_versions ppev,

420: CURSOR get_all_sub_proj_ass_det(cp_src_task_ver_id NUMBER,
421: cp_src_proj_id NUMBER) IS
422: SELECT porb.object_relationship_id lnk_obj_rel_id,
423: porb.record_version_number lnk_rel_rec_ver_number
424: FROM pa_proj_element_versions ppev,
425: pa_object_relationships pora,
426: pa_object_relationships porb,
427: pa_proj_elements ppe
428: WHERE pora.relationship_type = 'S'