DBA Data[Home] [Help]

APPS.EAM_WO_VALIDATE_PVT dependencies on HR_ORGANIZATION_UNITS

Line 188: from hr_organization_units hou

184: where mp.organization_id = p_eam_wo_rec.organization_id;
185:
186: select nvl(hou.date_to,sysdate+1)
187: into l_disable_date
188: from hr_organization_units hou
189: where organization_id = p_eam_wo_rec.organization_id;
190:
191: if(l_disable_date < sysdate) then
192: raise fnd_api.g_exc_unexpected_error;

Line 681: from hr_organization_units hou

677: where mp.organization_id = p_eam_wo_rec.organization_id;
678:
679: select nvl(hou.date_to,sysdate+1)
680: into l_disable_date
681: from hr_organization_units hou
682: where organization_id = p_eam_wo_rec.organization_id;
683:
684: if(l_disable_date < sysdate) then
685: raise fnd_api.g_exc_unexpected_error;