APPS.PA_ALLOC_UTILS dependencies on PA_ALLOC_RUNS_ALL

Line 67: FROM PA_ALLOC_RUNS_ALL PAR

63: OR PAL.ALLOC_RESOURCE_LIST_ID=P_resource_list_id
64: )
65: OR EXISTS
66: (SELECT 'Y'
67: FROM PA_ALLOC_RUNS_ALL PAR
68: WHERE PAR.BASIS_RESOURCE_LIST_ID=P_resource_list_id
69: OR PAR.ALLOC_RESOURCE_LIST_ID=P_resource_list_id
70: );
71: v_ret_code varchar2(1) ;

Line 386: FROM PA_ALLOC_RUNS_ALL

382: FROM PA_ALLOC_RULES_ALL
383: WHERE basis_budget_type_code=p_budget_type_code)
384: OR EXISTS
385: (SELECT 'Y'
386: FROM PA_ALLOC_RUNS_ALL
387: WHERE basis_budget_type_code=p_budget_type_code);
388:
389: v_ret_code varchar2(1) ;
390: v_dummy varchar2(1);

Line 429: FROM PA_ALLOC_RUNS_ALL

425: FROM PA_ALLOC_RULES_ALL
426: WHERE basis_budget_entry_method_code=p_bem_code)
427: OR EXISTS
428: (SELECT 'Y'
429: FROM PA_ALLOC_RUNS_ALL
430: WHERE basis_budget_entry_method_code=p_bem_code);
431:
432: v_ret_code varchar2(1) ;
433: v_dummy varchar2(1);

Line 489: /* Checking PA_ALLOC_RUNS_ALL */

485: Exception
486: When No_Data_Found Then
487: l_exists := 'N';
488: End;
489: /* Checking PA_ALLOC_RUNS_ALL */
490: Begin
491: Select 'Y' into l_exists
492: from pa_alloc_runs_all /* Bug 4185336 Changed from pa_alloc_rules to pa_alloc_rules_all */
493: where (

Line 492: from pa_alloc_runs_all /* Bug 4185336 Changed from pa_alloc_rules to pa_alloc_rules_all */

488: End;
489: /* Checking PA_ALLOC_RUNS_ALL */
490: Begin
491: Select 'Y' into l_exists
492: from pa_alloc_runs_all /* Bug 4185336 Changed from pa_alloc_rules to pa_alloc_rules_all */
493: where (
494: ( ALLOC_RESOURCE_STRUCT_TYPE = 'RBS'
495: and
496: Alloc_resource_list_id = P_RBS_ID

Line 543: From pa_alloc_runs_all par, PA_ALLOC_RUN_SOURCE_DET pars

539:
540: End;
541: Begin
542: Select 'Y' into l_exists
543: From pa_alloc_runs_all par, PA_ALLOC_RUN_SOURCE_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.ALLOC_RESOURCE_STRUCT_TYPE = 'RBS'

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'