APPS.PA_PROJECT_STRUCTURE_UTILS dependencies on PA_RESOURCE_LISTS_ALL_BG

Line 5457: pa_resource_lists_all_bg prla, pa_resource_lists_tl prl, pa_proj_fp_options ppfo

5453: IS
5454: l_resource_class_flag VARCHAR2(1) := 'Y';
5455: BEGIN
5456: SELECT nvl(prla.resource_class_flag, 'Y') INTO l_resource_class_flag FROM pa_projects_all ppa,
5457: pa_resource_lists_all_bg prla, pa_resource_lists_tl prl, pa_proj_fp_options ppfo
5458: where ppa.project_id = p_project_id and prla.resource_list_id = ppfo.cost_resource_list_id
5459: AND ppfo.fin_plan_option_level_code = 'PLAN_TYPE'
5460: AND ppfo.project_id = ppa.project_id AND prl.resource_list_id = prla.resource_list_id
5461: AND prl.language = userenv('LANG') AND ppfo.fin_plan_type_id = 10;