APPS.PJI_PJP_SUM_DENORM dependencies on PA_RBS_ELEMENTS

Line 4382: -- PA_RBS_ELEMENTS

4378: --
4379: -- *** This API assumes that the following tables exist and that they are
4380: -- properly populated (no cycles, correct relationships, etc)
4381: --
4382: -- PA_RBS_ELEMENTS
4383: --
4384: -- Then, this API populates output values in the following existing
4385: -- table:
4386: -- PJI_FP_AGGR_RBS

Line 4431: from PA_RBS_ELEMENTS pvt_level

4427: if P_EXTRACTION_TYPE = 'FULL'
4428: then
4429: select max(pvt_level.rbs_level)
4430: into l_rbs_level_id
4431: from PA_RBS_ELEMENTS pvt_level
4432: where 1=1
4433: and pvt_level.user_created_flag = 'N';
4434:
4435: elsif (

Line 4445: from PA_RBS_ELEMENTS pvt_level,

4441: )
4442: then
4443: select max(pvt_level.rbs_level)
4444: into l_rbs_level_id
4445: from PA_RBS_ELEMENTS pvt_level,
4446: (
4447: select distinct event_type, event_object
4448: from PJI_PA_PROJ_EVENTS_LOG
4449: where 1=1

Line 4461: from PA_RBS_ELEMENTS pvt_level

4457: elsif P_EXTRACTION_TYPE = 'UPGRADE'
4458: then
4459: select max(pvt_level.rbs_level)
4460: into l_rbs_level_id
4461: from PA_RBS_ELEMENTS pvt_level
4462: where 1=1
4463: and pvt_level.user_created_flag = 'N'
4464: and pvt_level.rbs_version_id = P_RBS_VERSION_ID;
4465:

Line 4533: from PA_RBS_ELEMENTS pvt_nodes1,

4529: pvt_nodes1.rbs_version_id, -- pvt_nodes.proj_element_id,
4530: pvt_nodes1.rbs_element_id, -- pvt_nodes.element_version_id,
4531: pvt_nodes1.parent_element_id -- pvt_nodes.parent_structure_version_id,
4532: -- pvt_nodes.rbs_group
4533: from PA_RBS_ELEMENTS pvt_nodes1,
4534: pji_pjp_proj_batch_map map,
4535: pa_rbs_prj_assignments assignments
4536: where 1=1
4537: and P_EXTRACTION_TYPE = 'FULL'

Line 4558: from PA_RBS_ELEMENTS pvt_nodes2,

4554: pvt_nodes2.rbs_version_id, -- pvt_nodes.proj_element_id,
4555: pvt_nodes2.rbs_element_id, -- pvt_nodes.element_version_id,
4556: pvt_nodes2.parent_element_id -- pvt_nodes.parent_structure_version_id,
4557: -- pvt_nodes.rbs_group
4558: from PA_RBS_ELEMENTS pvt_nodes2,
4559: (
4560: select
4561: distinct
4562: log1.event_type, log1.event_object

Line 4587: from PA_RBS_ELEMENTS pvt_nodes1

4583: pvt_nodes1.rbs_version_id, -- pvt_nodes.proj_element_id,
4584: pvt_nodes1.rbs_element_id, -- pvt_nodes.element_version_id,
4585: pvt_nodes1.parent_element_id -- pvt_nodes.parent_structure_version_id,
4586: -- pvt_nodes.rbs_group
4587: from PA_RBS_ELEMENTS pvt_nodes1
4588: where 1=1
4589: and P_EXTRACTION_TYPE = 'UPGRADE'
4590: and pvt_nodes1.user_created_flag = 'N'
4591: and (

Line 4690: from PA_RBS_ELEMENTS prt_parent

4686: (
4687: select
4688: distinct
4689: prt_parent.parent_element_id
4690: from PA_RBS_ELEMENTS prt_parent
4691: where 1=1
4692: and prt_parent.user_created_flag = 'N'
4693: and prt_parent.rbs_element_id = RBS_NODE.rbs_element_id -- prt_parent.child_id
4694: ) LOOP

Line 4904: -- PA_RBS_ELEMENTS

4900: --
4901: -- *** This API assumes that the following tables exist and that they are
4902: -- properly populated (no cycles, correct relationships, etc)
4903: --
4904: -- PA_RBS_ELEMENTS
4905: --
4906: -- Then, this API populates output values in the following existing
4907: -- table:
4908: -- PJI_FP_AGGR_RBS_T

Line 4949: from PA_RBS_ELEMENTS pvt_level

4945: -- Get deepest RBS node level --
4946:
4947: select max(pvt_level.rbs_level)
4948: into l_rbs_level_id
4949: from PA_RBS_ELEMENTS pvt_level
4950: where 1=1
4951: and pvt_level.user_created_flag = 'N'
4952: and pvt_level.rbs_version_id = P_RBS_VERSION_ID;
4953:

Line 5002: from PA_RBS_ELEMENTS pvt_nodes1

4998: pvt_nodes1.rbs_version_id, -- pvt_nodes.proj_element_id,
4999: pvt_nodes1.rbs_element_id, -- pvt_nodes.element_version_id,
5000: pvt_nodes1.parent_element_id -- pvt_nodes.parent_structure_version_id,
5001: -- pvt_nodes.rbs_group
5002: from PA_RBS_ELEMENTS pvt_nodes1
5003: where 1=1
5004: and pvt_nodes1.user_created_flag = 'N'
5005: and (
5006: pvt_nodes1.rbs_level = l_rbs_level_id

Line 5104: from PA_RBS_ELEMENTS prt_parent

5100: (
5101: select
5102: distinct
5103: prt_parent.parent_element_id
5104: from PA_RBS_ELEMENTS prt_parent
5105: where 1=1
5106: and prt_parent.user_created_flag = 'N'
5107: and prt_parent.rbs_element_id = RBS_NODE.rbs_element_id -- prt_parent.child_id
5108: ) LOOP