APPS.PA_PROCESS_CI_LINES_PKG dependencies on PA_PROJ_ELEM_VER_STRUCTURE

Line 116: from pa_proj_element_versions pev,pa_proj_elem_ver_structure pevs

112:
113:
114: cursor get_elem_ver_id (c_project_id number, c_task_id number) is
115: select pev.element_version_id,parent_structure_version_id
116: from pa_proj_element_versions pev,pa_proj_elem_ver_structure pevs
117: where pev.project_id = c_project_id
118: and pev.project_id = pevs.project_id
119: and pev.proj_element_id = c_task_id
120: and pev.parent_structure_version_id = pevs.element_version_id

Line 670: from pa_proj_element_versions pev, pa_proj_elem_ver_structure pevs

666: and pt.task_id = ppe.proj_element_id;
667:
668: cursor get_elem_ver_id (c_proj_id number, c_task_id number) is
669: select pev.element_version_id
670: from pa_proj_element_versions pev, pa_proj_elem_ver_structure pevs
671: where pev.project_id = c_proj_id and pev.project_id=pevs.project_id
672: and pev.proj_element_id=c_task_id
673: and pev.parent_structure_version_id=pevs.element_version_id
674: --and pevs.CURRENT_WORKING_FLAG='Y';

Line 852: from pa_proj_element_versions pev, pa_proj_elem_ver_structure pevs

848:
849:
850: cursor get_elem_ver_id (c_proj_id number, c_task_id number) is
851: select pev.element_version_id
852: from pa_proj_element_versions pev, pa_proj_elem_ver_structure pevs
853: where pev.project_id = c_proj_id
854: and pev.project_id=pevs.project_id
855: and pev.proj_element_id=c_task_id
856: and pev.parent_structure_version_id=pevs.element_version_id