APPS.PA_ALLOC_UTILS dependencies on PA_ALLOC_RUN_BASIS_DET

Line 26: FROM PA_ALLOC_RUN_BASIS_DET BASIS

22: WHERE SRC.RESOURCE_LIST_MEMBER_ID=P_resource_list_member_id
23: )
24: OR EXISTS
25: (SELECT 'Y'
26: FROM PA_ALLOC_RUN_BASIS_DET BASIS
27: WHERE BASIS.RESOURCE_LIST_MEMBER_ID=P_resource_list_member_id
28: );
29: v_ret_code varchar2(1) ;
30: v_dummy varchar2(1);

Line 556: From pa_alloc_runs_all par, PA_ALLOC_RUN_BASIS_DET pars

552: l_exists := 'N';
553: End;
554: Begin
555: Select 'Y' into l_exists
556: From pa_alloc_runs_all par, PA_ALLOC_RUN_BASIS_DET pars
557: Where par.run_id = pars.run_id
558: and par.rule_id = pars.rule_id
559: and RESOURCE_LIST_MEMBER_ID = P_RBS_ELEMENT_ID
560: and par.BASIS_RESOURCE_STRUCT_TYPE = 'RBS'