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 373: FROM PA_ALLOC_RUNS_ALL

369: FROM PA_ALLOC_RULES_ALL
370: WHERE basis_budget_type_code=p_budget_type_code)
371: OR EXISTS
372: (SELECT 'Y'
373: FROM PA_ALLOC_RUNS_ALL
374: WHERE basis_budget_type_code=p_budget_type_code);
375:
376: v_ret_code varchar2(1) ;
377: v_dummy varchar2(1);

Line 416: FROM PA_ALLOC_RUNS_ALL

412: FROM PA_ALLOC_RULES_ALL
413: WHERE basis_budget_entry_method_code=p_bem_code)
414: OR EXISTS
415: (SELECT 'Y'
416: FROM PA_ALLOC_RUNS_ALL
417: WHERE basis_budget_entry_method_code=p_bem_code);
418:
419: v_ret_code varchar2(1) ;
420: v_dummy varchar2(1);

Line 476: /* Checking PA_ALLOC_RUNS_ALL */

472: Exception
473: When No_Data_Found Then
474: l_exists := 'N';
475: End;
476: /* Checking PA_ALLOC_RUNS_ALL */
477: Begin
478: Select 'Y' into l_exists
479: from pa_alloc_runs_all /* Bug 4185336 Changed from pa_alloc_rules to pa_alloc_rules_all */
480: where (

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

475: End;
476: /* Checking PA_ALLOC_RUNS_ALL */
477: Begin
478: Select 'Y' into l_exists
479: from pa_alloc_runs_all /* Bug 4185336 Changed from pa_alloc_rules to pa_alloc_rules_all */
480: where (
481: ( ALLOC_RESOURCE_STRUCT_TYPE = 'RBS'
482: and
483: Alloc_resource_list_id = P_RBS_ID

Line 530: From pa_alloc_runs_all par, PA_ALLOC_RUN_SOURCE_DET pars

526:
527: End;
528: Begin
529: Select 'Y' into l_exists
530: From pa_alloc_runs_all par, PA_ALLOC_RUN_SOURCE_DET pars
531: Where par.run_id = pars.run_id
532: and par.rule_id = pars.rule_id
533: and RESOURCE_LIST_MEMBER_ID = P_RBS_ELEMENT_ID
534: and par.ALLOC_RESOURCE_STRUCT_TYPE = 'RBS'

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'