APPS.EAM_OP_VALIDATE_PVT dependencies on BOM_DEPARTMENT_RESOURCES_V

Line 1071: select count(*) into l_rowcount from BOM_DEPARTMENT_RESOURCES_V where DEPARTMENT_ID=p_dept_id and RESOURCE_CODE=p_res_code;

1067:
1068: function validate_dept_res(p_dept_id number , p_res_code varchar2) return varchar2 is
1069: l_rowcount number := 0;
1070: begin
1071: select count(*) into l_rowcount from BOM_DEPARTMENT_RESOURCES_V where DEPARTMENT_ID=p_dept_id and RESOURCE_CODE=p_res_code;
1072: if(l_rowcount > 0) then
1073: return 'Y';
1074: end if;
1075: return 'N';