APPS.PA_WORKPLAN_WORKFLOW dependencies on PA_PROJ_ELEM_VER_STRUCTURE

Line 98: from pa_proj_elem_ver_structure

94: l_ret VARCHAR2(240);
95:
96: cursor getWorkplanStatus IS
97: select STATUS_CODE
98: from pa_proj_elem_ver_structure
99: where project_id = l_project_id
100: and element_version_id = l_structure_version_id;
101:
102: cursor get_working_ver(c_structure_version_id NUMBER) IS

Line 104: from pa_proj_elem_ver_structure a,

100: and element_version_id = l_structure_version_id;
101:
102: cursor get_working_ver(c_structure_version_id NUMBER) IS
103: select a.element_version_id
104: from pa_proj_elem_ver_structure a,
105: pa_proj_element_versions b
106: where b.project_id = a.project_id
107: and b.proj_element_id = a.proj_element_id
108: and a.status_code = 'STRUCTURE_WORKING'

Line 191: update pa_proj_elem_ver_structure

187: itemtype => itemtype
188: ,itemkey => itemkey
189: ,aname => 'RECORD_VERSION_NUMBER');
190:
191: update pa_proj_elem_ver_structure
192: set status_code = 'STRUCTURE_WORKING',
193: record_version_number = l_record_version_num + 1
194: where project_id = l_project_id
195: and element_version_id = l_structure_version_id;