APPS.PA_CI_SUPPLIER_PKG dependencies on PA_PROJ_ELEMENT_VERSIONS

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:

Line 272: l_struct_elem_version_id Pa_proj_element_versions.element_version_id%TYPE := -1;

268: l_attribute_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
269: l_attribute1_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
270: l_scheduled_delay SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
271: l_direct_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
272: l_struct_elem_version_id Pa_proj_element_versions.element_version_id%TYPE := -1;
273:
274:
275:
276: BEGIN