APPS.PJI_FM_PLAN_MAINT dependencies on PA_PROJ_ELEM_VER_STRUCTURE

Line 1847: l_request_id pa_proj_elem_ver_structure.conc_request_id%TYPE;

1843:
1844: l_project_id NUMBER;
1845: l_plan_version_id NUMBER;
1846: l_wbs_version_id NUMBER;
1847: l_request_id pa_proj_elem_ver_structure.conc_request_id%TYPE;
1848:
1849: BEGIN
1850:
1851: -- Fix for bug : 4027718

Line 1858: FROM pa_proj_elem_ver_structure a ,

1854: SELECT a.process_update_wbs_flag, a.element_version_id
1855: , a.project_id, b.plan_version_id
1856: INTO g_process_update_wbs_flag, l_wbs_version_id
1857: , l_project_id, l_plan_version_id
1858: FROM pa_proj_elem_ver_structure a ,
1859: PJI_FM_EXTR_PLNVER3_T b
1860: WHERE a.element_version_id = b.wbs_struct_version_id
1861: AND a.project_id = b.project_id -- 4902584
1862: AND ROWNUM <= 1;