APPS.PA_WORKPLAN_AMG_PUB dependencies on PA_PROJ_ELEM_VER_STRUCTURE

Line 21: from pa_proj_elem_ver_structure

17: )IS
18:
19: cursor version_info IS
20: select record_version_number
21: from pa_proj_elem_ver_structure
22: where element_version_id = p_structure_version_id
23: and project_id = p_pa_project_id;
24:
25: cursor struct_info is

Line 27: from pa_proj_elem_ver_structure

23: and project_id = p_pa_project_id;
24:
25: cursor struct_info is
26: select pev_structure_id
27: from pa_proj_elem_ver_structure
28: where element_version_id = p_structure_version_id
29: and project_id = p_pa_project_id;
30:
31:

Line 210: from PA_proj_elem_ver_structure

206:
207: )IS
208: cursor version_info IS
209: select pev_structure_id, record_version_number,name
210: from PA_proj_elem_ver_structure
211: where element_version_id = p_structure_version_id
212: and project_id = p_pa_project_id;
213:
214: l_api_version_number CONSTANT NUMBER := G_API_VERSION_NUMBER;

Line 220: l_record_version_number pa_proj_elem_ver_structure.record_version_number%type;

216: l_module_name VARCHAR2(80);
217: l_responsibility_id NUMBER := 0;
218: l_user_id NUMBER := 0;
219: l_function_allowed VARCHAR2(1) := 'N';
220: l_record_version_number pa_proj_elem_ver_structure.record_version_number%type;
221: l_name pa_proj_elem_ver_structure.name%type;
222: l_structure_id pa_proj_elem_ver_structure.pev_structure_id%type;
223:
224:

Line 221: l_name pa_proj_elem_ver_structure.name%type;

217: l_responsibility_id NUMBER := 0;
218: l_user_id NUMBER := 0;
219: l_function_allowed VARCHAR2(1) := 'N';
220: l_record_version_number pa_proj_elem_ver_structure.record_version_number%type;
221: l_name pa_proj_elem_ver_structure.name%type;
222: l_structure_id pa_proj_elem_ver_structure.pev_structure_id%type;
223:
224:
225:

Line 222: l_structure_id pa_proj_elem_ver_structure.pev_structure_id%type;

218: l_user_id NUMBER := 0;
219: l_function_allowed VARCHAR2(1) := 'N';
220: l_record_version_number pa_proj_elem_ver_structure.record_version_number%type;
221: l_name pa_proj_elem_ver_structure.name%type;
222: l_structure_id pa_proj_elem_ver_structure.pev_structure_id%type;
223:
224:
225:
226: str version_info%ROWTYPE;