DBA Data[Home] [Help]

APPS.PA_CI_SUPPLIER_PKG dependencies on PA_PROJ_ELEM_VER_STRUCTURE

Line 110: from pa_proj_element_versions pev,pa_proj_elem_ver_structure pevs

106: where ci_id = p_ci_id;
107:
108: cursor get_elem_ver_id (proj_id number) is
109: select pev.element_version_id,parent_structure_version_id
110: from pa_proj_element_versions pev,pa_proj_elem_ver_structure pevs
111: where pev.project_id=proj_id and pev.project_id=pevs.project_id
112: and pev.proj_element_id=p_task_id and pev.parent_structure_version_id=pevs.element_version_id
113: and pevs.CURRENT_FLAG='Y';
114:

Line 117: from pa_proj_element_versions pev,pa_proj_elem_ver_structure pevs

113: and pevs.CURRENT_FLAG='Y';
114:
115: cursor get_elem_ver_all_id (proj_id number) is
116: select pev.element_version_id,parent_structure_version_id
117: from pa_proj_element_versions pev,pa_proj_elem_ver_structure pevs
118: where pev.project_id=proj_id and pev.project_id=pevs.project_id
119: and pev.proj_element_id=p_task_id and pev.parent_structure_version_id=pevs.element_version_id
120: and pevs.CURRENT_WORKING_FLAG='Y';
121: