308: SELECT PROJFUNC_OPP_VALUE,
309: PROJECT_OPP_VALUE
310: INTO l_pfc_project_value,
311: l_pc_project_value
312: FROM PA_PROJECT_OPP_ATTRS
313: WHERE PROJECT_ID = P_FP_COLS_REC.X_PROJECT_ID;
314: EXCEPTION
315: WHEN NO_DATA_FOUND THEN
316: l_pfc_project_value := null;
345: SELECT PROJFUNC_OPP_VALUE,
346: PROJECT_OPP_VALUE
347: INTO l_pfc_project_value,
348: l_pc_project_value
349: FROM PA_PROJECT_OPP_ATTRS
350: WHERE PROJECT_ID = P_FP_COLS_REC.X_PROJECT_ID;
351: EXCEPTION
352: WHEN NO_DATA_FOUND THEN
353: l_pfc_project_value := null;
397: SELECT PROJFUNC_OPP_VALUE,
398: PROJECT_OPP_VALUE
399: INTO l_pfc_project_value,
400: l_pc_project_value
401: FROM PA_PROJECT_OPP_ATTRS
402: WHERE PROJECT_ID = P_FP_COLS_REC.X_PROJECT_ID;
403: EXCEPTION
404: WHEN NO_DATA_FOUND THEN
405: l_pfc_project_value := null;