APPS.PA_CREATE_RESOURCE dependencies on PA_RBS_ELEMENTS_TEMP

Line 4668: From Pa_Rbs_Elements_Temp;

4664:
4665: Begin
4666:
4667: Delete
4668: From Pa_Rbs_Elements_Temp;
4669:
4670: Exception
4671: When No_Data_Found Then
4672: null;

Line 4677: Insert Into Pa_Rbs_Elements_Temp(

4673:
4674: End;
4675:
4676:
4677: Insert Into Pa_Rbs_Elements_Temp(
4678: New_Element_Id,
4679: Old_Element_Id,
4680: Old_Parent_Element_Id,
4681: New_Parent_Element_Id )

Line 4695: Update Pa_Rbs_Elements_Temp Tmp1

4691: and enabled_flag <> 'N' );
4692:
4693: --Update the parent member ID for the new child elements:
4694:
4695: Update Pa_Rbs_Elements_Temp Tmp1
4696: Set New_Parent_Element_Id =
4697: (Select New_Element_Id
4698: From Pa_Rbs_Elements_Temp Tmp2
4699: Where Tmp1.Old_Parent_Element_Id = Tmp2.Old_Element_Id);

Line 4698: From Pa_Rbs_Elements_Temp Tmp2

4694:
4695: Update Pa_Rbs_Elements_Temp Tmp1
4696: Set New_Parent_Element_Id =
4697: (Select New_Element_Id
4698: From Pa_Rbs_Elements_Temp Tmp2
4699: Where Tmp1.Old_Parent_Element_Id = Tmp2.Old_Element_Id);
4700:
4701:
4702: --Copy all the elements of parent_resource_list to the newly created resource list

Line 4898: From Pa_resource_list_members a, Pa_Rbs_Elements_Temp Tmp

4894: -- Bug 3636926
4895: a.UNIT_OF_MEASURE,
4896: --a.MIGRATED_RBS_ELEMENT_ID
4897: a.EXPENDITURE_TYPE_2 --Added for Bug13655396
4898: From Pa_resource_list_members a, Pa_Rbs_Elements_Temp Tmp
4899: Where Tmp.Old_Element_Id = a.resource_list_member_id;
4900:
4901: --End: Bug 3710189
4902: /*