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 528: From PA_ALLOC_RULES_ALL par, PA_ALLOC_RESOURCES pr

524: l_exists Varchar2(1) := 'N';
525: BEGIN
526: Begin
527: Select 'Y' into l_exists
528: From PA_ALLOC_RULES_ALL par, PA_ALLOC_RESOURCES pr
529: Where par.rule_id = pr.rule_id
530: and pr.RESOURCE_LIST_MEMBER_ID = P_RBS_ELEMENT_ID
531: and decode (pr.member_type , 'S' , par.ALLOC_RESOURCE_STRUCT_TYPE ,
532: 'B' , par.BASIS_RESOURCE_STRUCT_TYPE

Line 668: Update pa_alloc_resources ARS

664: Update pa_alloc_rules_all
665: Set alloc_rbs_version = p_rbs_version_id
666: Where RULE_ID = ALLOC_CUR.RULE_ID;
667:
668: Update pa_alloc_resources ARS
669: Set resource_list_member_id = (
670: select new.rbs_element_id
671: from pa_rbs_elements new
672: ,pa_rbs_elements old

Line 694: Update pa_alloc_resources ARS

690: Update pa_alloc_rules_all
691: Set basis_rbs_version = p_rbs_version_id
692: Where RULE_ID = ALLOC_CUR.RULE_ID;
693:
694: Update pa_alloc_resources ARS
695: Set resource_list_member_id = (
696: select new.rbs_element_id
697: from pa_rbs_elements new
698: ,pa_rbs_elements old

Line 713: Update pa_alloc_resources ARS

709:
710: END LOOP;
711:
712: /* Commenting out the code for bug 4107924
713: Update pa_alloc_resources ARS
714: Set resource_list_member_id = (
715: select new.rbs_element_id
716: from pa_rbs_elements new
717: ,pa_rbs_elements old