APPS.EAM_OP_VALIDATE_PVT dependencies on BOM_DEPT_RES_INSTANCES_EMP_V

Line 1138: where EXISTS (select ROW_ID from BOM_DEPT_RES_INSTANCES_EMP_V

1134: function validate_dept_res_instance(p_dept_id number , p_inst_id number, p_res_id Number) return varchar2 is
1135: l_rowcount number := 0;
1136: begin
1137: select count(*) into l_rowcount from dual
1138: where EXISTS (select ROW_ID from BOM_DEPT_RES_INSTANCES_EMP_V
1139: where DEPARTMENT_ID=p_dept_id and INSTANCE_ID=p_inst_id and RESOURCE_ID=p_res_id);
1140: if(l_rowcount > 0) then
1141: return 'N';
1142: end if;