APPS.EAM_OP_VALIDATE_PVT dependencies on BOM_DEPARTMENT_RESOURCES_V

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

1118:
1119: function validate_dept_res(p_dept_id number , p_res_code varchar2) return varchar2 is
1120: l_rowcount number := 0;
1121: begin
1122: select count(*) into l_rowcount from BOM_DEPARTMENT_RESOURCES_V where DEPARTMENT_ID=p_dept_id and RESOURCE_CODE=p_res_code;
1123: if(l_rowcount > 0) then
1124: return 'Y';
1125: end if;
1126: return 'N';