APPS.PJI_PJP_SUM_DENORM dependencies on PA_RBS_ELEMENTS

Line 4448: -- PA_RBS_ELEMENTS

4444: --
4445: -- *** This API assumes that the following tables exist and that they are
4446: -- properly populated (no cycles, correct relationships, etc)
4447: --
4448: -- PA_RBS_ELEMENTS
4449: --
4450: -- Then, this API populates output values in the following existing
4451: -- table:
4452: -- PJI_FP_AGGR_RBS

Line 4509: from PA_RBS_ELEMENTS pvt_level

4505: if P_EXTRACTION_TYPE = 'FULL'
4506: then
4507: select max(pvt_level.rbs_level)
4508: into l_rbs_level_id
4509: from PA_RBS_ELEMENTS pvt_level
4510: where 1=1
4511: and pvt_level.user_created_flag = 'N';
4512:
4513: elsif (

Line 4523: from PA_RBS_ELEMENTS pvt_level,

4519: )
4520: then
4521: select max(pvt_level.rbs_level)
4522: into l_rbs_level_id
4523: from PA_RBS_ELEMENTS pvt_level,
4524: (
4525: select distinct event_type, event_object
4526: from PJI_PA_PROJ_EVENTS_LOG
4527: where 1=1

Line 4539: from PA_RBS_ELEMENTS pvt_level

4535: elsif P_EXTRACTION_TYPE = 'UPGRADE'
4536: then
4537: select max(pvt_level.rbs_level)
4538: into l_rbs_level_id
4539: from PA_RBS_ELEMENTS pvt_level
4540: where 1=1
4541: and pvt_level.user_created_flag = 'N'
4542: and pvt_level.rbs_version_id = P_RBS_VERSION_ID;
4543:

Line 4611: from PA_RBS_ELEMENTS pvt_nodes1 /* Modified for bug 11843459 */

4607: pvt_nodes1.rbs_version_id, -- pvt_nodes.proj_element_id,
4608: pvt_nodes1.rbs_element_id, -- pvt_nodes.element_version_id,
4609: pvt_nodes1.parent_element_id -- pvt_nodes.parent_structure_version_id,
4610: -- pvt_nodes.rbs_group
4611: from PA_RBS_ELEMENTS pvt_nodes1 /* Modified for bug 11843459 */
4612:
4613:
4614: where 1=1
4615: and P_EXTRACTION_TYPE = 'FULL'

Line 4639: from PA_RBS_ELEMENTS pvt_nodes2,

4635: pvt_nodes2.rbs_version_id, -- pvt_nodes.proj_element_id,
4636: pvt_nodes2.rbs_element_id, -- pvt_nodes.element_version_id,
4637: pvt_nodes2.parent_element_id -- pvt_nodes.parent_structure_version_id,
4638: -- pvt_nodes.rbs_group
4639: from PA_RBS_ELEMENTS pvt_nodes2,
4640: (
4641: select
4642: distinct
4643: log1.event_type, log1.event_object

Line 4671: from PA_RBS_ELEMENTS pvt_nodes2,

4667: distinct
4668: pvt_nodes2.rbs_version_id,
4669: pvt_nodes2.rbs_element_id,
4670: pvt_nodes2.parent_element_id
4671: from PA_RBS_ELEMENTS pvt_nodes2,
4672: (
4673: select
4674: distinct
4675: log1.event_type, log1.event_object

Line 4702: from PA_RBS_ELEMENTS pvt_nodes1

4698: pvt_nodes1.rbs_version_id, -- pvt_nodes.proj_element_id,
4699: pvt_nodes1.rbs_element_id, -- pvt_nodes.element_version_id,
4700: pvt_nodes1.parent_element_id -- pvt_nodes.parent_structure_version_id,
4701: -- pvt_nodes.rbs_group
4702: from PA_RBS_ELEMENTS pvt_nodes1
4703: where 1=1
4704: and P_EXTRACTION_TYPE = 'UPGRADE'
4705: and pvt_nodes1.user_created_flag = 'N'
4706: and (

Line 4827: from PA_RBS_ELEMENTS prt_parent

4823: (
4824: select
4825: distinct
4826: prt_parent.parent_element_id
4827: from PA_RBS_ELEMENTS prt_parent
4828: where 1=1
4829: and prt_parent.user_created_flag = 'N'
4830: and prt_parent.rbs_element_id = RBS_NODE.rbs_element_id -- prt_parent.child_id
4831: ) LOOP

Line 5089: -- PA_RBS_ELEMENTS

5085: --
5086: -- *** This API assumes that the following tables exist and that they are
5087: -- properly populated (no cycles, correct relationships, etc)
5088: --
5089: -- PA_RBS_ELEMENTS
5090: --
5091: -- Then, this API populates output values in the following existing
5092: -- table:
5093: -- PJI_FP_AGGR_RBS_T

Line 5153: from PA_RBS_ELEMENTS pvt_level

5149: -- Get deepest RBS node level --
5150:
5151: select max(pvt_level.rbs_level)
5152: into l_rbs_level_id
5153: from PA_RBS_ELEMENTS pvt_level
5154: where 1=1
5155: and pvt_level.user_created_flag = 'N'
5156: and pvt_level.rbs_version_id = P_RBS_VERSION_ID;
5157:

Line 5206: from PA_RBS_ELEMENTS pvt_nodes1

5202: pvt_nodes1.rbs_version_id, -- pvt_nodes.proj_element_id,
5203: pvt_nodes1.rbs_element_id, -- pvt_nodes.element_version_id,
5204: pvt_nodes1.parent_element_id -- pvt_nodes.parent_structure_version_id,
5205: -- pvt_nodes.rbs_group
5206: from PA_RBS_ELEMENTS pvt_nodes1
5207: where 1=1
5208: and pvt_nodes1.user_created_flag = 'N'
5209: and (
5210: pvt_nodes1.rbs_level = l_rbs_level_id

Line 5229: from PA_RBS_ELEMENTS pvt_nodes1

5225: distinct
5226: pvt_nodes1.rbs_version_id,
5227: pvt_nodes1.rbs_element_id,
5228: pvt_nodes1.parent_element_id
5229: from PA_RBS_ELEMENTS pvt_nodes1
5230: where 1=1
5231: and pvt_nodes1.user_created_flag = 'N'
5232: and (
5233: pvt_nodes1.rbs_level = l_rbs_level_id

Line 5349: from PA_RBS_ELEMENTS prt_parent

5345: (
5346: select
5347: distinct
5348: prt_parent.parent_element_id
5349: from PA_RBS_ELEMENTS prt_parent
5350: where 1=1
5351: and prt_parent.user_created_flag = 'N'
5352: and prt_parent.rbs_element_id = RBS_NODE.rbs_element_id -- prt_parent.child_id
5353: ) LOOP

Line 6220: from PA_RBS_ELEMENTS pvt_level,

6216: if P_EXTRACTION_TYPE = 'RBS' then
6217:
6218: select max(pvt_level.rbs_level)
6219: into l_rbs_level_id
6220: from PA_RBS_ELEMENTS pvt_level,
6221: (
6222: select distinct event_type, event_object
6223: from PJI_PA_PROJ_EVENTS_LOG
6224: where 1=1

Line 6286: from PA_RBS_ELEMENTS pvt_nodes2,

6282: pvt_nodes2.rbs_version_id, -- pvt_nodes.proj_element_id,
6283: pvt_nodes2.rbs_element_id, -- pvt_nodes.element_version_id,
6284: pvt_nodes2.parent_element_id -- pvt_nodes.parent_structure_version_id,
6285: -- pvt_nodes.rbs_group
6286: from PA_RBS_ELEMENTS pvt_nodes2,
6287: (
6288: select
6289: distinct
6290: log1.event_type, log1.event_object

Line 6383: from PA_RBS_ELEMENTS prt_parent

6379: (
6380: select
6381: distinct
6382: prt_parent.parent_element_id
6383: from PA_RBS_ELEMENTS prt_parent
6384: where 1=1
6385: and prt_parent.user_created_flag = 'N'
6386: and prt_parent.rbs_element_id = RBS_NODE.rbs_element_id -- prt_parent.child_id
6387: ) LOOP