1013: wip_logger.log('This is a shift resource. Need to validate shift setup', l_retStatus);
1014: begin
1015: select 1
1016: into l_dummy
1017: from dual
1018: where exists (select 1
1019: from bom_resource_shifts brs,
1020: mtl_parameters mp,
1021: bom_shift_dates bsd,
1797: wip_logger.log('This is a shift resource. Need to validate shift setup', l_retStatus);
1798: begin
1799: select 1
1800: into l_dummy
1801: from dual
1802: where exists (select 1
1803: from bom_resource_shifts brs,
1804: mtl_parameters mp,
1805: bom_shift_dates bsd,