APPS.PA_ALLOC_RUN dependencies on PA_ALLOC_RESOURCES

Line 4540: pa_alloc_resources par

4536: nvl(pbr.parent_member_id,0) parent_member_id,
4537: par.resource_percentage
4538: from pa_resource_list_members pbr,
4539: /** pa_budget_resources_v pbr, ** bug 2661889 */
4540: pa_alloc_resources par
4541: where par.rule_id = p_rule_id
4542: and par.member_type = p_type
4543: and pbr.resource_list_member_id = par.resource_list_member_id
4544: and display_flag = 'Y' /* FP.M : Allocation Impact Bug # 3512552 */

Line 4555: pa_alloc_resources par

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
4559: and prbs.rbs_version_id = p_rbs_version_id

Line 4576: * from pa_alloc_resources

4572: * where resource_list_id = p_resource_list_id
4573: * -- 2564418 changes start
4574: * AND resource_list_member_id NOT IN
4575: * (select resource_list_member_id
4576: * from pa_alloc_resources
4577: * where exclude_flag='Y'
4578: * AND rule_id = p_rule_id);
4579: * -- 2564418 changes end.
4580: ****************** End of comment *****************************/

Line 4624: from pa_alloc_resources par

4620: And enabled_flag = 'Y' /* FP.M : Allocation Impact Bug # 3512552 */
4621: And nvl(prlm.migration_code , 'M') = 'M'
4622: AND NOT exists
4623: (select par.resource_list_member_id
4624: from pa_alloc_resources par
4625: where par.exclude_flag = 'Y'
4626: And par.member_type = p_type /* Bug 3819804 */
4627: AND par.rule_id = p_rule_id
4628: and prlm.resource_list_member_id = par.resource_list_member_id

Line 4639: From pa_alloc_resources par

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
4639: From pa_alloc_resources par
4640: Where par.exclude_flag = 'Y'
4641: And par.member_type = p_type /* Bug 3819804 */
4642: AND par.rule_id = p_rule_id
4643: AND prbs.rbs_element_id = par.resource_list_member_id

Line 4659: From pa_alloc_resources par

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
4659: From pa_alloc_resources par
4660: Where par.exclude_flag = 'Y'
4661: And par.member_type = p_type /* Bug 3819804 */
4662: AND par.rule_id = p_rule_id
4663: AND prbs.rbs_element_id = par.resource_list_member_id

Line 4708: From pa_alloc_resources

4704: Bug # 3567201 : Child Exlcusion When Parent Exlcluded
4705: */
4706: Cursor C_Exc_RLM Is
4707: Select Resource_List_Member_Id
4708: From pa_alloc_resources
4709: Where Rule_Id = P_Rule_Id
4710: And Member_Type = P_type
4711: And Exclude_Flag = 'Y';
4712: /* FP.M : Allocation Impact Bug # 3512552

Line 4722: from pa_alloc_resources

4718: IS
4719: v_rlm_excluded VARCHAR2(1) ;
4720: cursor c_rlm_excluded is
4721: Select 'Y'
4722: from pa_alloc_resources
4723: where rule_id = p_rule_id
4724: and member_type = p_type
4725: and resource_list_member_id = p_rlm_id
4726: and exclude_flag = 'Y' ;

Line 4746: from pa_alloc_resources

4742: IS
4743: v_rlm_exists VARCHAR2(1);
4744: cursor c_rlm_exists is
4745: select 'Y'
4746: from pa_alloc_resources
4747: where rule_id = p_rule_id
4748: and member_type = p_type ;
4749: BEGIN
4750: v_rlm_exists := 'N' ;