APPS.PA_ALLOC_UTILS dependencies on PA_ALLOC_RESOURCES

Line 16: FROM PA_ALLOC_RESOURCES RE

12: CURSOR C_resource_list_member IS
13: SELECT '1'
14: FROM dual
15: WHERE EXISTS (SELECT 'Y'
16: FROM PA_ALLOC_RESOURCES RE
17: WHERE RE.RESOURCE_LIST_MEMBER_ID=P_resource_list_member_id
18: )
19: OR EXISTS
20: (SELECT 'Y'

Line 515: From PA_ALLOC_RULES_ALL par, PA_ALLOC_RESOURCES pr

511: l_exists Varchar2(1) := 'N';
512: BEGIN
513: Begin
514: Select 'Y' into l_exists
515: From PA_ALLOC_RULES_ALL par, PA_ALLOC_RESOURCES pr
516: Where par.rule_id = pr.rule_id
517: and pr.RESOURCE_LIST_MEMBER_ID = P_RBS_ELEMENT_ID
518: and decode (pr.member_type , 'S' , par.ALLOC_RESOURCE_STRUCT_TYPE ,
519: 'B' , par.BASIS_RESOURCE_STRUCT_TYPE

Line 655: Update pa_alloc_resources ARS

651: Update pa_alloc_rules_all
652: Set alloc_rbs_version = p_rbs_version_id
653: Where RULE_ID = ALLOC_CUR.RULE_ID;
654:
655: Update pa_alloc_resources ARS
656: Set resource_list_member_id = (
657: select new.rbs_element_id
658: from pa_rbs_elements new
659: ,pa_rbs_elements old

Line 681: Update pa_alloc_resources ARS

677: Update pa_alloc_rules_all
678: Set basis_rbs_version = p_rbs_version_id
679: Where RULE_ID = ALLOC_CUR.RULE_ID;
680:
681: Update pa_alloc_resources ARS
682: Set resource_list_member_id = (
683: select new.rbs_element_id
684: from pa_rbs_elements new
685: ,pa_rbs_elements old

Line 700: Update pa_alloc_resources ARS

696:
697: END LOOP;
698:
699: /* Commenting out the code for bug 4107924
700: Update pa_alloc_resources ARS
701: Set resource_list_member_id = (
702: select new.rbs_element_id
703: from pa_rbs_elements new
704: ,pa_rbs_elements old