DBA Data[Home] [Help]

APPS.PA_PROJ_ACCUM_MAIN dependencies on PA_ALLOC_TXN_DETAILS

Line 926: AND EXISTS ( select 1 from pa_alloc_txn_details alloc

922: UNION
923: SELECT proj.project_id , proj.segment1 ,proj.project_type
924: FROM pa_projects proj
925: WHERE proj.segment1 BETWEEN l_project_num_from AND l_project_num_to
926: AND EXISTS ( select 1 from pa_alloc_txn_details alloc
927: where alloc.project_id = proj.project_id
928: AND alloc.run_id = pa_accum_utils.Get_grouping_id)
929: AND pa_accum_utils.Get_context_info = 'AUTO_ALLOCATION'
930: AND proj.project_type = NVL(x_project_type, project_type)