DBA Data[Home] [Help]

APPS.EAM_WO_VALIDATE_PVT dependencies on HR_ORGANIZATION_UNITS

Line 189: from hr_organization_units hou

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

Line 648: from hr_organization_units hou

644: where mp.organization_id = p_eam_wo_rec.organization_id;
645:
646: select nvl(hou.date_to,sysdate+1)
647: into l_disable_date
648: from hr_organization_units hou
649: where organization_id = p_eam_wo_rec.organization_id;
650:
651: if(l_disable_date < sysdate) then
652: raise fnd_api.g_exc_unexpected_error;