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 543: From pa_alloc_runs_all par, PA_ALLOC_RUN_BASIS_DET pars

539: l_exists := 'N';
540: End;
541: Begin
542: Select 'Y' into l_exists
543: From pa_alloc_runs_all par, PA_ALLOC_RUN_BASIS_DET pars
544: Where par.run_id = pars.run_id
545: and par.rule_id = pars.rule_id
546: and RESOURCE_LIST_MEMBER_ID = P_RBS_ELEMENT_ID
547: and par.BASIS_RESOURCE_STRUCT_TYPE = 'RBS'