DBA Data[Home] [Help]

APPS.EAM_RES_VALIDATE_PVT dependencies on BOM_SHIFT_TIMES

Line 764: from bom_shift_times shf,

760: -- available_24_hours_flag is '1' for 24 hr resource and '2' for not 24 hr resource
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