APPS.PJI_REP_UTIL dependencies on PA_PROJ_ELEMENTS

Line 151: FROM pa_tasks t1 , pa_proj_elements emt,pa_proj_element_versions ver,

147: SELECT t1.project_id , 'N', t1.project_id , nvl(t1.parent_task_id , p_elem_id ) parent_task_id ,
148: t1.task_id ,'N' ,emt.name,'Y' ,decode(nvl(t2.parent_task_id ,-1) , -1 , 'N', 'Y' ),
149: SYSDATE, SYSDATE, 1, 1,
150: 0 ,t_element_version_id, ver.display_sequence,t_element_version_id, 'WF'
151: FROM pa_tasks t1 , pa_proj_elements emt,pa_proj_element_versions ver,
152: ( select distinct parent_task_id from pa_tasks t3 where t3.project_id = p_project_id ) t2
153: where t1.project_id = p_project_id
154: and t1.task_id = t2.parent_task_id (+)
155: AND t1.task_id = emt.PROJ_ELEMENT_ID

Line 547: FROM pji_xbs_denorm denorm, pa_proj_elements emt,pa_proj_element_versions ver

543: SELECT denorm.sup_project_id,'N',denorm.sup_project_id,denorm.sup_emt_id,
544: denorm.sub_emt_id,'N',emt.name,DECODE(denorm.sub_level-sup_level,0,'N','Y'),DECODE(denorm.sub_leaf_flag,'Y','N','Y'),
545: SYSDATE, SYSDATE, 1, 1,
546: 0 ,p_element_version_id, ver.display_sequence,p_element_version_id, denorm.relationship_type
547: FROM pji_xbs_denorm denorm, pa_proj_elements emt,pa_proj_element_versions ver
548: WHERE 1=1
549: AND denorm.sup_project_id = p_project_id
550: AND denorm.struct_version_id = p_element_version_id
551: AND denorm.sub_level - denorm.sup_level<=1

Line 584: , pa_proj_elements emt

580: , ver.display_sequence
581: , p_element_version_id
582: , denorm.relationship_type
583: FROM pji_xbs_denorm denorm
584: , pa_proj_elements emt
585: ,pa_proj_element_versions ver
586: WHERE 1=1
587: AND denorm.sup_project_id = p_project_id
588: AND denorm.sub_emt_id = emt.proj_element_id

Line 677: FROM pji_xbs_denorm denorm, pa_proj_elem_ver_structure struct_ver, pa_proj_elements emt

673: ,p_element_version_id
674: , 0
675: , denorm.sup_id
676: , 'WF'
677: FROM pji_xbs_denorm denorm, pa_proj_elem_ver_structure struct_ver, pa_proj_elements emt
678: WHERE 1=1
679: AND denorm.sup_project_id = p_project_id
680: AND denorm.sup_id = p_element_version_id
681: AND denorm.struct_version_id IS NULL

Line 714: FROM pa_proj_elements emt, pji_xbs_denorm denorm,

710: ,p_element_version_id
711: , ver.display_sequence
712: ,denorm.struct_version_id
713: , denorm.relationship_type
714: FROM pa_proj_elements emt, pji_xbs_denorm denorm,
715: (SELECT sub_id wbs_version_id, sub_leaf_flag
716: FROM pji_xbs_denorm
717: WHERE 1=1
718: AND sup_project_id = p_project_id

Line 764: , pa_proj_elements emt

760: , ver.display_sequence
761: , denorm.struct_version_id
762: , denorm.relationship_type
763: FROM pji_xbs_denorm denorm
764: , pa_proj_elements emt
765: , (SELECT sub_id wbs_version_id, sub_leaf_flag
766: FROM pji_xbs_denorm
767: WHERE 1=1
768: AND sup_project_id = p_project_id

Line 810: FROM pji_xbs_denorm denorm, pa_proj_elem_ver_structure struct_ver,pa_proj_elements emt

806: ,p_element_version_id
807: , -1
808: , sub_id
809: , denorm.relationship_type
810: FROM pji_xbs_denorm denorm, pa_proj_elem_ver_structure struct_ver,pa_proj_elements emt
811: , (SELECT sub_id wbs_version_id, sub_leaf_flag
812: FROM pji_xbs_denorm
813: WHERE 1=1
814: AND sup_project_id = p_project_id

Line 945: , pa_proj_elements elem

941: MAX(DECODE(header_p.plan_version_id,p_plan2_version_id,header.plan_version_id,NULL)),
942: MAX(DECODE(header_p.plan_version_id,p_current_version_id,header.wbs_version_id,NULL))
943: FROM
944: pji_xbs_denorm denorm
945: , pa_proj_elements elem
946: , pji_pjp_wbs_header header
947: , pji_pjp_wbs_header header_p
948: WHERE 1=1
949: AND header_p.project_id = p_project_id

Line 3803: FROM pa_proj_elements

3799:
3800: BEGIN
3801: SELECT object_type
3802: INTO l_object_type
3803: FROM pa_proj_elements
3804: WHERE proj_element_id = p_wbs_element_id;
3805: EXCEPTION
3806: WHEN NO_DATA_FOUND THEN
3807: l_object_type := 'PA_STRUCTURES';

Line 4070: pa_proj_elements ele,

4066: c_currency_code pa_projects_all.project_currency_code%TYPE)
4067: IS
4068: SELECT 1
4069: FROM pji_xbs_denorm denorm,
4070: pa_proj_elements ele,
4071: pa_projects_all proj
4072: WHERE denorm.sup_project_id = c_project_id
4073: AND denorm.sup_id = c_wbs_version_id
4074: AND denorm.struct_type = 'PRG'

Line 4086: pa_proj_elements ele,

4082: c_currency_code pa_projects_all.project_currency_code%TYPE)
4083: IS
4084: SELECT 1
4085: FROM pji_xbs_denorm denorm,
4086: pa_proj_elements ele,
4087: pa_projects_all proj
4088: WHERE denorm.sup_project_id = c_project_id
4089: AND denorm.sup_id = c_wbs_version_id
4090: AND denorm.struct_type = 'PRG'

Line 4291: pa_proj_elements ele

4287: c_published_flag VARCHAR2)
4288: IS
4289: SELECT 1
4290: FROM pji_xbs_denorm denorm,
4291: pa_proj_elements ele
4292: WHERE denorm.sup_project_id = c_project_id
4293: AND denorm.sup_id = c_wbs_version_id
4294: AND denorm.struct_type = 'PRG'
4295: AND denorm.struct_version_id IS NULL

Line 5192: , pa_proj_elements elem

5188: INTO l_num_of_gl_cal,
5189: l_num_of_pa_cal
5190: FROM
5191: pji_xbs_denorm denorm
5192: , pa_proj_elements elem
5193: , pa_projects_all proj
5194: , pji_org_extr_info info
5195: WHERE 1=1
5196: AND denorm.sup_project_id = p_project_id -- project_id

Line 5283: , pa_proj_elements elem

5279: SELECT COUNT(DISTINCT proj.projfunc_currency_code)
5280: INTO l_num_of_projfunc_curr
5281: FROM
5282: pji_xbs_denorm denorm
5283: , pa_proj_elements elem
5284: , pa_projects_all proj
5285: WHERE 1=1
5286: AND denorm.sup_project_id = p_project_id -- project_id
5287: AND denorm.sup_id = p_wbs_version_id -- wbs_version_id

Line 6167: , pa_proj_elements elem

6163: Select count(*)
6164: INTO l_count
6165: FROM
6166: pji_xbs_denorm denorm
6167: , pa_proj_elements elem
6168: , pa_proj_elem_ver_structure ppevs
6169: WHERE 1=1
6170: AND denorm.sup_project_id = p_project_id
6171: AND denorm.sup_id = p_structure_version_id