APPS.PA_ALLOC_RUN dependencies on PA_ALLOC_RESOURCES

Line 4517: pa_alloc_resources par

4513: nvl(pbr.parent_member_id,0) parent_member_id,
4514: par.resource_percentage
4515: from pa_resource_list_members pbr,
4516: /** pa_budget_resources_v pbr, ** bug 2661889 */
4517: pa_alloc_resources par
4518: where par.rule_id = p_rule_id
4519: and par.member_type = p_type
4520: and pbr.resource_list_member_id = par.resource_list_member_id
4521: and display_flag = 'Y' /* FP.M : Allocation Impact Bug # 3512552 */

Line 4532: pa_alloc_resources par

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

Line 4553: * from pa_alloc_resources

4549: * where resource_list_id = p_resource_list_id
4550: * -- 2564418 changes start
4551: * AND resource_list_member_id NOT IN
4552: * (select resource_list_member_id
4553: * from pa_alloc_resources
4554: * where exclude_flag='Y'
4555: * AND rule_id = p_rule_id);
4556: * -- 2564418 changes end.
4557: ****************** End of comment *****************************/

Line 4601: from pa_alloc_resources par

4597: And enabled_flag = 'Y' /* FP.M : Allocation Impact Bug # 3512552 */
4598: And nvl(prlm.migration_code , 'M') = 'M'
4599: AND NOT exists
4600: (select par.resource_list_member_id
4601: from pa_alloc_resources par
4602: where par.exclude_flag = 'Y'
4603: And par.member_type = p_type /* Bug 3819804 */
4604: AND par.rule_id = p_rule_id
4605: and prlm.resource_list_member_id = par.resource_list_member_id

Line 4616: From pa_alloc_resources par

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
4616: From pa_alloc_resources par
4617: Where par.exclude_flag = 'Y'
4618: And par.member_type = p_type /* Bug 3819804 */
4619: AND par.rule_id = p_rule_id
4620: AND prbs.rbs_element_id = par.resource_list_member_id

Line 4636: From pa_alloc_resources par

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

Line 4685: From pa_alloc_resources

4681: Bug # 3567201 : Child Exlcusion When Parent Exlcluded
4682: */
4683: Cursor C_Exc_RLM Is
4684: Select Resource_List_Member_Id
4685: From pa_alloc_resources
4686: Where Rule_Id = P_Rule_Id
4687: And Member_Type = P_type
4688: And Exclude_Flag = 'Y';
4689: /* FP.M : Allocation Impact Bug # 3512552

Line 4699: from pa_alloc_resources

4695: IS
4696: v_rlm_excluded VARCHAR2(1) ;
4697: cursor c_rlm_excluded is
4698: Select 'Y'
4699: from pa_alloc_resources
4700: where rule_id = p_rule_id
4701: and member_type = p_type
4702: and resource_list_member_id = p_rlm_id
4703: and exclude_flag = 'Y' ;

Line 4723: from pa_alloc_resources

4719: IS
4720: v_rlm_exists VARCHAR2(1);
4721: cursor c_rlm_exists is
4722: select 'Y'
4723: from pa_alloc_resources
4724: where rule_id = p_rule_id
4725: and member_type = p_type ;
4726: BEGIN
4727: v_rlm_exists := 'N' ;