DBA Data[Home] [Help]

APPS.ENG_VAL_TO_ID dependencies on PA_PROJECTS_ALL

Line 393: Changed the Table name from mtl_projects_v to PA_PROJECTS_ALL

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

Line 398: FROM pa_projects_all

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: