1236: begin
1237: -- Bug 16322124 . Modified for Performance.
1238: select 1
1239: into l_dummy
1240: from dual
1241: where exists (select 1
1242: from bom_resource_shifts brs,
1243: bom_department_resources bdr
1244: where bdr.department_id = x_resTbls.deptID(p_idx)
2361: begin
2362: -- Bug 16322124 . Modified for Performance.
2363: select 1
2364: into l_dummy
2365: from dual
2366: where exists (select 1
2367: from bom_resource_shifts brs,
2368: bom_department_resources bdr
2369: where bdr.department_id = x_resTbls.deptID(p_idx)