APPS.EAM_RES_VALIDATE_PVT dependencies on BOM_RESOURCE_SHIFTS

Line 765: bom_resource_shifts rsh,

761:
762: if (l_24_hr_resource = 2) then
763: select count(rsh.shift_num) into l_count_shift_num
764: from bom_shift_times shf,
765: bom_resource_shifts rsh,
766: bom_department_resources bdr
767: where bdr.department_id = p_eam_res_rec.department_id
768: and bdr.resource_id = p_eam_res_rec.resource_id
769: and nvl(bdr.share_from_dept_id, bdr.department_id) = rsh.department_id