APPS.EAM_OP_VALIDATE_PVT dependencies on BOM_DEPT_RES_INSTANCES_EMP_V

Line 1087: where EXISTS (select ROW_ID from BOM_DEPT_RES_INSTANCES_EMP_V

1083: function validate_dept_res_instance(p_dept_id number , p_inst_id number, p_res_id Number) return varchar2 is
1084: l_rowcount number := 0;
1085: begin
1086: select count(*) into l_rowcount from dual
1087: where EXISTS (select ROW_ID from BOM_DEPT_RES_INSTANCES_EMP_V
1088: where DEPARTMENT_ID=p_dept_id and INSTANCE_ID=p_inst_id and RESOURCE_ID=p_res_id);
1089: if(l_rowcount > 0) then
1090: return 'N';
1091: end if;