DBA Data[Home] [Help]

APPS.PA_PROJ_ACCUM_MAIN dependencies on PA_ALLOC_TXN_DETAILS

Line 957: AND EXISTS ( select 1 from pa_alloc_txn_details alloc

953: UNION
954: SELECT proj.project_id , proj.segment1 ,proj.project_type
955: FROM pa_projects proj
956: WHERE proj.segment1 BETWEEN l_project_num_from AND l_project_num_to
957: AND EXISTS ( select 1 from pa_alloc_txn_details alloc
958: where alloc.project_id = proj.project_id
959: AND alloc.run_id = pa_accum_utils.Get_grouping_id)
960: AND pa_accum_utils.Get_context_info = 'AUTO_ALLOCATION'
961: AND proj.project_type = NVL(x_project_type, project_type)