APPS.PA_ALLOC_RUN dependencies on PA_RBS_ELEMENTS

Line 4554: From pa_rbs_elements prbs,

4550: Select par.resource_list_member_id ,
4551: par.exclude_flag ,
4552: nvl(prbs.parent_element_id , 0) parent_member_id ,
4553: par.resource_percentage
4554: From pa_rbs_elements prbs,
4555: pa_alloc_resources par
4556: Where par.rule_id = p_rule_id
4557: and prbs.user_created_flag = 'N' /* To show only those elements created after summarization process */
4558: and par.member_type = p_type

Line 4594: From pa_rbs_elements prbs

4590: This cursor will be used When no include and no exclude is defined.
4591: This cursor is used only in source and basis ( if the basis_category is actuals )
4592: */
4593: Select prbs.rbs_element_id
4594: From pa_rbs_elements prbs
4595: Where prbs.rbs_version_id = p_rbs_version_id
4596: and prbs.user_created_flag = 'N' /* To show only those elements created after summarization process */
4597: and prbs.resource_type_id <> -1 /* To remove first record of Version Info*/
4598: and Not Exists (Select '1'

Line 4599: From pa_rbs_elements rbs_chd

4595: Where prbs.rbs_version_id = p_rbs_version_id
4596: and prbs.user_created_flag = 'N' /* To show only those elements created after summarization process */
4597: and prbs.resource_type_id <> -1 /* To remove first record of Version Info*/
4598: and Not Exists (Select '1'
4599: From pa_rbs_elements rbs_chd
4600: Where rbs_chd.rbs_version_id = p_rbs_version_id
4601: and rbs_chd.user_created_flag = 'N' /* To show only those elements created after summarization process */
4602: And rbs_chd.parent_element_id = prbs.rbs_element_id
4603: ); /* To select only Leaf nodes in case of Actuals */

Line 4610: From pa_rbs_elements prbs

4606: This cursor is used only in basis and basis category is not actuals. Only
4607: If the basis Category is Finplan or Budgets
4608: */
4609: Select prbs.rbs_element_id
4610: From pa_rbs_elements prbs
4611: Where prbs.rbs_version_id = p_rbs_version_id
4612: and prbs.user_created_flag = 'N' /* To show only those elements created after summarization process */
4613: and prbs.resource_type_id <> -1 ; /* To remove first record of Version Info*/
4614: /* In this case, data can be there for intermediate nodes also. So to insert all the records */

Line 4634: From pa_rbs_elements prbs

4630: AND p_resource_struct_type = 'RL';
4631: /* FP.M : Allocation Impact Bug # 3512552 */
4632: Cursor C_RL_RLM_RBS_ACT is
4633: Select prbs.rbs_element_id
4634: From pa_rbs_elements prbs
4635: Where prbs.rbs_version_id = p_rbs_version_id
4636: and prbs.user_created_flag = 'N' /* To show only those elements created after summarization process */
4637: and NOT exists
4638: (Select par.resource_list_member_id

Line 4646: From pa_rbs_elements chd_prbs

4642: AND par.rule_id = p_rule_id
4643: AND prbs.rbs_element_id = par.resource_list_member_id
4644: )
4645: and Not Exists ( Select '1'
4646: From pa_rbs_elements chd_prbs
4647: where chd_prbs.rbs_version_id = p_rbs_Version_id
4648: and chd_prbs.user_created_flag = 'N' /* To show only those elements created after summarization process */
4649: And chd_prbs.parent_element_id = prbs.rbs_element_id
4650: ) /* To fetch only leaf nodes */

Line 4654: From pa_rbs_elements prbs

4650: ) /* To fetch only leaf nodes */
4651: and p_resource_struct_type = 'RBS';
4652: Cursor C_RL_RLM_RBS_NON_ACT is
4653: Select prbs.rbs_element_id
4654: From pa_rbs_elements prbs
4655: Where prbs.rbs_version_id = p_rbs_version_id
4656: and prbs.user_created_flag = 'N' /* To show only those elements created after summarization process */
4657: and NOT exists
4658: (Select par.resource_list_member_id

Line 4682: From pa_rbs_elements prbs

4678: and p_resource_struct_type = 'RL';
4679: /* FP.M : Allocation Impact Bug # 3512552 */
4680: Cursor C_RG_RLM_RBS_ACT Is
4681: Select Rbs_Element_Id resource_list_member_id
4682: From pa_rbs_elements prbs
4683: Where Rbs_Version_Id = p_rbs_version_id
4684: and prbs.user_created_flag = 'N' /* To show only those elements created after summarization process */
4685: AND p_resource_struct_type = 'RBS'
4686: AND Not Exists (

Line 4688: From pa_rbs_elements chd_prbs

4684: and prbs.user_created_flag = 'N' /* To show only those elements created after summarization process */
4685: AND p_resource_struct_type = 'RBS'
4686: AND Not Exists (
4687: Select '1'
4688: From pa_rbs_elements chd_prbs
4689: Where chd_prbs.rbs_version_id = p_rbs_version_id
4690: and chd_prbs.user_created_flag = 'N' /* To show only those elements created after summarization process */
4691: and chd_prbs.parent_element_id = prbs.rbs_element_id
4692: )

Line 4697: From pa_rbs_elements prbs

4693: Start with Rbs_Element_Id = v_rlm_id
4694: Connect By Prior rbs_element_id = parent_element_id;
4695: Cursor C_RG_RLM_RBS_NON_ACT Is
4696: Select Rbs_Element_Id resource_list_member_id
4697: From pa_rbs_elements prbs
4698: Where Rbs_Version_Id = p_rbs_version_id
4699: and prbs.user_created_flag = 'N' /* To show only those elements created after summarization process */
4700: AND p_resource_struct_type = 'RBS'
4701: Start with Rbs_Element_Id = v_rlm_id

Line 4776: From pa_rbs_elements

4772: And nvl(migration_code , 'M') = 'M';
4773: /* FP.M : Allocation Impact : Bug # 3512552 */
4774: cursor c_child_rbs_rlm Is
4775: Select 'Y'
4776: From pa_rbs_elements
4777: Where rbs_version_id = p_rbs_version_id
4778: and user_created_flag = 'N' /* To show only those elements created after summarization process */
4779: And Nvl(parent_element_id,0) = p_rlm_id
4780: And RowNum = 1;

Line 4948: From pa_rbs_elements

4944: Declare
4945: Cursor C_Exc_Chd_Rlm_RBS (V_parent_rlm in Number)
4946: Is
4947: Select Rbs_Element_Id resource_list_member_id
4948: From pa_rbs_elements
4949: Where Rbs_Version_Id = p_rbs_version_id
4950: and user_created_flag = 'N' /* To show only those elements created after summarization process */
4951: And p_resource_struct_type = 'RBS'
4952: Start With Parent_element_Id = V_parent_Rlm