APPS.PJI_FM_PLAN_MAINT dependencies on PA_PROJ_ELEM_VER_STRUCTURE

Line 1787: l_request_id pa_proj_elem_ver_structure.conc_request_id%TYPE;

1783:
1784: l_project_id NUMBER;
1785: l_plan_version_id NUMBER;
1786: l_wbs_version_id NUMBER;
1787: l_request_id pa_proj_elem_ver_structure.conc_request_id%TYPE;
1788:
1789: BEGIN
1790:
1791: -- Fix for bug : 4027718

Line 1798: FROM pa_proj_elem_ver_structure a ,

1794: SELECT a.process_update_wbs_flag, a.element_version_id
1795: , a.project_id, b.plan_version_id
1796: INTO g_process_update_wbs_flag, l_wbs_version_id
1797: , l_project_id, l_plan_version_id
1798: FROM pa_proj_elem_ver_structure a ,
1799: PJI_FM_EXTR_PLNVER3_T b
1800: WHERE a.element_version_id = b.wbs_struct_version_id
1801: AND a.project_id = b.project_id -- 4902584
1802: AND ROWNUM <= 1;