APPS.PA_LIFECYCLES_PUB dependencies on PA_PROJ_ELEMENTS

Line 289: Where exists(SELECT 'XYZ' from pa_proj_elements

285: CURSOR l_get_lifecycle_csr
286: IS
287: Select 'Y'
288: From dual
289: Where exists(SELECT 'XYZ' from pa_proj_elements
290: WHERE proj_element_id = P_lifecycle_id
291: AND object_type='PA_STRUCTURES'
292: AND project_id=c_project_id);
293:

Line 552: Where exists(SELECT 'XYZ' from pa_proj_elements

548: CURSOR l_get_lifecycle_csr
549: IS
550: Select 'Y'
551: From dual
552: Where exists(SELECT 'XYZ' from pa_proj_elements
553: WHERE proj_element_id = P_lifecycle_id
554: AND object_type= c_object_type
555: AND project_id=c_project_id
556: );

Line 562: , pa_proj_elements elem

558: CURSOR l_phases_csr
559: IS
560: Select elem.proj_element_id, elem.record_version_number
561: From pa_proj_element_versions ever
562: , pa_proj_elements elem
563: Where ever.parent_structure_version_id = l_life_elem_ver_id
564: AND ever.object_type= 'PA_TASKS'
565: AND ever.project_id=c_project_id
566: AND ever.proj_element_id = elem.proj_element_id

Line 1304: from pa_proj_elements

1300:
1301: BEGIN
1302: select name,element_number,description
1303: into l_lcyl_name,l_short_name,l_lifecycle_description
1304: from pa_proj_elements
1305: where proj_element_id=l_lifecycle_id
1306: AND object_type = c_object_type
1307: AND project_id = c_project_id;
1308: EXCEPTION

Line 1354: Where exists(Select 'XYZ' from pa_proj_elements

1350: BEGIN
1351: Select 'N'
1352: Into l_shname_uniq
1353: from SYS.DUAL
1354: Where exists(Select 'XYZ' from pa_proj_elements
1355: where element_number = P_lifecycle_short_name
1356: AND object_type=c_object_type
1357: AND project_id = c_project_id);
1358: exception

Line 1684: from pa_proj_elements prj

1680:
1681: BEGIN
1682: select prj.name,prj.element_number,prj.description,prj.phase_code,elem.display_sequence
1683: into l_phase_name,l_phase_short_name,l_phase_description,l_phase_code,l_seqn
1684: from pa_proj_elements prj
1685: , pa_proj_element_versions elem
1686: where prj.proj_element_id=P_lifecycle_phase_id
1687: and prj.project_id=c_project_id
1688: and prj.object_type=c_object_type