APPS.PA_PROGRESS_PUB dependencies on PA_PROJ_STRUCTURE_TYPES

Line 4486: pa_proj_structure_types pst

4482: CURSOR cur_get_wk_ver_struct_id IS
4483: select str.element_version_id
4484: from pa_proj_elem_ver_structure str,
4485: pa_proj_elements pe,
4486: pa_proj_structure_types pst
4487: where pe.project_id = p_project_id
4488: and pe.project_id = str.project_id
4489: and pe.proj_element_id = str.proj_element_id
4490: and str.status_code <> 'STRUCTURE_PUBLISHED'

Line 4503: pa_proj_structure_types pst

4499: CURSOR cur_get_only_ver_struct_id IS
4500: select str.element_version_id
4501: from pa_proj_elem_ver_structure str,
4502: pa_proj_elements pe,
4503: pa_proj_structure_types pst
4504: where pe.project_id = p_project_id
4505: and pe.project_id = str.project_id
4506: and pe.proj_element_id = str.proj_element_id
4507: and pe.proj_element_id = pst.proj_element_id

Line 8571: PA_Proj_Structure_Types ppst,

8567: IS
8568: Select ppevs.element_version_id
8569: FROM PA_Proj_Elem_Ver_Structure ppevs,
8570: PA_Proj_Elements ppe,
8571: PA_Proj_Structure_Types ppst,
8572: PA_Structure_types pst
8573: WHERE ppevs.Project_ID = P_Project_ID
8574: AND ppevs.status_code = 'STRUCTURE_PUBLISHED'
8575: AND ppevs.proj_element_id = ppe.Proj_Element_ID

Line 19659: , pa_proj_structure_types pstype

19655: SELECT distinct asgn.project_id project_id, asgn.structure_version_id structure_version_id
19656: FROM pa_task_asgmts_v asgn
19657: , pa_proj_elem_ver_structure str
19658: , pa_proj_progress_attr prog
19659: , pa_proj_structure_types pstype
19660: WHERE asgn.person_id = p_person_id
19661: AND asgn.structure_version_id = str.element_version_id
19662: AND asgn.project_id = str.project_id
19663: AND str.latest_eff_published_flag = 'Y'

Line 19674: , pa_proj_structure_types pstype

19670: SELECT distinct elem.project_id project_id, str.element_version_id structure_version_id
19671: FROM pa_proj_elements elem
19672: , pa_proj_elem_ver_structure str
19673: , pa_proj_progress_attr prog
19674: , pa_proj_structure_types pstype
19675: WHERE elem.manager_person_id = p_person_id
19676: AND elem.object_type = 'PA_TASKS'
19677: AND elem.project_id = str.project_id
19678: AND str.latest_eff_published_flag = 'Y'

Line 20087: PA_Proj_Structure_Types ppst,

20083: Cursor cur_Summerized_Actuals IS
20084: Select count(1)
20085: FROM PA_Proj_Elem_Ver_Structure ppevs,
20086: PA_Proj_Elements ppe,
20087: PA_Proj_Structure_Types ppst,
20088: PA_Structure_types pst
20089: WHERE ppevs.Project_ID = P_Project_ID
20090: AND ppevs.status_code = 'STRUCTURE_PUBLISHED'
20091: AND ppevs.proj_element_id = ppe.Proj_Element_ID