DBA Data[Home] [Help]

APPS.PA_ALLOC_UTILS dependencies on PA_ALLOC_RUN_SOURCE_DET

Line 21: FROM PA_ALLOC_RUN_SOURCE_DET SRC

17: WHERE RE.RESOURCE_LIST_MEMBER_ID=P_resource_list_member_id
18: )
19: OR EXISTS
20: (SELECT 'Y'
21: FROM PA_ALLOC_RUN_SOURCE_DET SRC
22: WHERE SRC.RESOURCE_LIST_MEMBER_ID=P_resource_list_member_id
23: )
24: OR EXISTS
25: (SELECT 'Y'

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'