APPS.PA_FP_ADJUSTMENT_UTILS dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 173: FROM pa_proj_element_versions

169: AND name.language=userenv('LANG');
170:
171: CURSOR C_Get_Object_Type (p_wbs_element_id IN NUMBER, p_wbs_structure_version_id IN NUMBER) IS
172: SELECT object_type
173: FROM pa_proj_element_versions
174: WHERE proj_element_id = p_wbs_element_id
175: AND element_version_id = p_wbs_structure_version_id;
176:
177: l_structure_version_id varchar2(2000);

Line 178: l_object_type pa_proj_element_versions.object_type%TYPE;

174: WHERE proj_element_id = p_wbs_element_id
175: AND element_version_id = p_wbs_structure_version_id;
176:
177: l_structure_version_id varchar2(2000);
178: l_object_type pa_proj_element_versions.object_type%TYPE;
179: l_project_level_node_flag varchar2(1) := 'N';
180: l_workplan_costs_enabled_flag pa_proj_fp_options.track_workplan_costs_flag%TYPE;
181:
182: BEGIN

Line 868: FROM pa_proj_element_versions

864: and ra.task_id = 0;
865:
866: CURSOR C_Get_Object_Type (p_wbs_element_id IN NUMBER, p_wbs_structure_version_id IN NUMBER) IS
867: SELECT object_type
868: FROM pa_proj_element_versions
869: WHERE proj_element_id = p_wbs_element_id
870: AND element_version_id = p_wbs_structure_version_id;
871:
872: l_object_type pa_proj_element_versions.object_type%TYPE;

Line 872: l_object_type pa_proj_element_versions.object_type%TYPE;

868: FROM pa_proj_element_versions
869: WHERE proj_element_id = p_wbs_element_id
870: AND element_version_id = p_wbs_structure_version_id;
871:
872: l_object_type pa_proj_element_versions.object_type%TYPE;
873: l_project_level_node_flag varchar2(1) := 'N';
874:
875: l_t_id NUMBER;
876: l_t_code VARCHAR2(15);