389: ret_code NUMBER;
390: BEGIN
391:
392: /*
393: Changed the Table name from mtl_projects_v to PA_PROJECTS_ALL
394: to avoid the Non-Mergeable view Performance issues
395: */
396: SELECT project_id
397: INTO l_id
394: to avoid the Non-Mergeable view Performance issues
395: */
396: SELECT project_id
397: INTO l_id
398: FROM pa_projects_all
399: WHERE name = p_project_name;
400:
401: RETURN l_id;
402: