APPS.PA_CREATE_RESOURCE dependencies on PA_RBS_ELEMENTS_TEMP

Line 4315: From Pa_Rbs_Elements_Temp;

4311:
4312: Begin
4313:
4314: Delete
4315: From Pa_Rbs_Elements_Temp;
4316:
4317: Exception
4318: When No_Data_Found Then
4319: null;

Line 4324: Insert Into Pa_Rbs_Elements_Temp(

4320:
4321: End;
4322:
4323:
4324: Insert Into Pa_Rbs_Elements_Temp(
4325: New_Element_Id,
4326: Old_Element_Id,
4327: Old_Parent_Element_Id,
4328: New_Parent_Element_Id )

Line 4342: Update Pa_Rbs_Elements_Temp Tmp1

4338: and enabled_flag <> 'N' );
4339:
4340: --Update the parent member ID for the new child elements:
4341:
4342: Update Pa_Rbs_Elements_Temp Tmp1
4343: Set New_Parent_Element_Id =
4344: (Select New_Element_Id
4345: From Pa_Rbs_Elements_Temp Tmp2
4346: Where Tmp1.Old_Parent_Element_Id = Tmp2.Old_Element_Id);

Line 4345: From Pa_Rbs_Elements_Temp Tmp2

4341:
4342: Update Pa_Rbs_Elements_Temp Tmp1
4343: Set New_Parent_Element_Id =
4344: (Select New_Element_Id
4345: From Pa_Rbs_Elements_Temp Tmp2
4346: Where Tmp1.Old_Parent_Element_Id = Tmp2.Old_Element_Id);
4347:
4348:
4349: --Copy all the elements of parent_resource_list to the newly created resource list

Line 4543: From Pa_resource_list_members a, Pa_Rbs_Elements_Temp Tmp

4539: a.WP_ELIGIBLE_FLAG,
4540: -- Bug 3636926
4541: a.UNIT_OF_MEASURE
4542: --a.MIGRATED_RBS_ELEMENT_ID
4543: From Pa_resource_list_members a, Pa_Rbs_Elements_Temp Tmp
4544: Where Tmp.Old_Element_Id = a.resource_list_member_id;
4545:
4546: --End: Bug 3710189
4547: /*