APPS.PA_ALLOC_RUN dependencies on PA_RBS_ELEMENTS

Line 4531: From pa_rbs_elements prbs,

4527: Select par.resource_list_member_id ,
4528: par.exclude_flag ,
4529: nvl(prbs.parent_element_id , 0) parent_member_id ,
4530: par.resource_percentage
4531: From pa_rbs_elements prbs,
4532: pa_alloc_resources par
4533: Where par.rule_id = p_rule_id
4534: and prbs.user_created_flag = 'N' /* To show only those elements created after summarization process */
4535: and par.member_type = p_type

Line 4571: From pa_rbs_elements prbs

4567: This cursor will be used When no include and no exclude is defined.
4568: This cursor is used only in source and basis ( if the basis_category is actuals )
4569: */
4570: Select prbs.rbs_element_id
4571: From pa_rbs_elements prbs
4572: Where prbs.rbs_version_id = p_rbs_version_id
4573: and prbs.user_created_flag = 'N' /* To show only those elements created after summarization process */
4574: and prbs.resource_type_id <> -1 /* To remove first record of Version Info*/
4575: and Not Exists (Select '1'

Line 4576: From pa_rbs_elements rbs_chd

4572: Where prbs.rbs_version_id = p_rbs_version_id
4573: and prbs.user_created_flag = 'N' /* To show only those elements created after summarization process */
4574: and prbs.resource_type_id <> -1 /* To remove first record of Version Info*/
4575: and Not Exists (Select '1'
4576: From pa_rbs_elements rbs_chd
4577: Where rbs_chd.rbs_version_id = p_rbs_version_id
4578: and rbs_chd.user_created_flag = 'N' /* To show only those elements created after summarization process */
4579: And rbs_chd.parent_element_id = prbs.rbs_element_id
4580: ); /* To select only Leaf nodes in case of Actuals */

Line 4587: From pa_rbs_elements prbs

4583: This cursor is used only in basis and basis category is not actuals. Only
4584: If the basis Category is Finplan or Budgets
4585: */
4586: Select prbs.rbs_element_id
4587: From pa_rbs_elements prbs
4588: Where prbs.rbs_version_id = p_rbs_version_id
4589: and prbs.user_created_flag = 'N' /* To show only those elements created after summarization process */
4590: and prbs.resource_type_id <> -1 ; /* To remove first record of Version Info*/
4591: /* In this case, data can be there for intermediate nodes also. So to insert all the records */

Line 4611: From pa_rbs_elements prbs

4607: AND p_resource_struct_type = 'RL';
4608: /* FP.M : Allocation Impact Bug # 3512552 */
4609: Cursor C_RL_RLM_RBS_ACT is
4610: Select prbs.rbs_element_id
4611: From pa_rbs_elements prbs
4612: Where prbs.rbs_version_id = p_rbs_version_id
4613: and prbs.user_created_flag = 'N' /* To show only those elements created after summarization process */
4614: and NOT exists
4615: (Select par.resource_list_member_id

Line 4623: From pa_rbs_elements chd_prbs

4619: AND par.rule_id = p_rule_id
4620: AND prbs.rbs_element_id = par.resource_list_member_id
4621: )
4622: and Not Exists ( Select '1'
4623: From pa_rbs_elements chd_prbs
4624: where chd_prbs.rbs_version_id = p_rbs_Version_id
4625: and chd_prbs.user_created_flag = 'N' /* To show only those elements created after summarization process */
4626: And chd_prbs.parent_element_id = prbs.rbs_element_id
4627: ) /* To fetch only leaf nodes */

Line 4631: From pa_rbs_elements prbs

4627: ) /* To fetch only leaf nodes */
4628: and p_resource_struct_type = 'RBS';
4629: Cursor C_RL_RLM_RBS_NON_ACT is
4630: Select prbs.rbs_element_id
4631: From pa_rbs_elements prbs
4632: Where prbs.rbs_version_id = p_rbs_version_id
4633: and prbs.user_created_flag = 'N' /* To show only those elements created after summarization process */
4634: and NOT exists
4635: (Select par.resource_list_member_id

Line 4659: From pa_rbs_elements prbs

4655: and p_resource_struct_type = 'RL';
4656: /* FP.M : Allocation Impact Bug # 3512552 */
4657: Cursor C_RG_RLM_RBS_ACT Is
4658: Select Rbs_Element_Id resource_list_member_id
4659: From pa_rbs_elements prbs
4660: Where Rbs_Version_Id = p_rbs_version_id
4661: and prbs.user_created_flag = 'N' /* To show only those elements created after summarization process */
4662: AND p_resource_struct_type = 'RBS'
4663: AND Not Exists (

Line 4665: From pa_rbs_elements chd_prbs

4661: and prbs.user_created_flag = 'N' /* To show only those elements created after summarization process */
4662: AND p_resource_struct_type = 'RBS'
4663: AND Not Exists (
4664: Select '1'
4665: From pa_rbs_elements chd_prbs
4666: Where chd_prbs.rbs_version_id = p_rbs_version_id
4667: and chd_prbs.user_created_flag = 'N' /* To show only those elements created after summarization process */
4668: and chd_prbs.parent_element_id = prbs.rbs_element_id
4669: )

Line 4674: From pa_rbs_elements prbs

4670: Start with Rbs_Element_Id = v_rlm_id
4671: Connect By Prior rbs_element_id = parent_element_id;
4672: Cursor C_RG_RLM_RBS_NON_ACT Is
4673: Select Rbs_Element_Id resource_list_member_id
4674: From pa_rbs_elements prbs
4675: Where Rbs_Version_Id = p_rbs_version_id
4676: and prbs.user_created_flag = 'N' /* To show only those elements created after summarization process */
4677: AND p_resource_struct_type = 'RBS'
4678: Start with Rbs_Element_Id = v_rlm_id

Line 4753: From pa_rbs_elements

4749: And nvl(migration_code , 'M') = 'M';
4750: /* FP.M : Allocation Impact : Bug # 3512552 */
4751: cursor c_child_rbs_rlm Is
4752: Select 'Y'
4753: From pa_rbs_elements
4754: Where rbs_version_id = p_rbs_version_id
4755: and user_created_flag = 'N' /* To show only those elements created after summarization process */
4756: And Nvl(parent_element_id,0) = p_rlm_id
4757: And RowNum = 1;

Line 4925: From pa_rbs_elements

4921: Declare
4922: Cursor C_Exc_Chd_Rlm_RBS (V_parent_rlm in Number)
4923: Is
4924: Select Rbs_Element_Id resource_list_member_id
4925: From pa_rbs_elements
4926: Where Rbs_Version_Id = p_rbs_version_id
4927: and user_created_flag = 'N' /* To show only those elements created after summarization process */
4928: And p_resource_struct_type = 'RBS'
4929: Start With Parent_element_Id = V_parent_Rlm