DBA Data[Home] [Help]

APPS.WSH_UTIL_VALIDATE dependencies on HR_ORGANIZATION_UNITS

Line 208: FROM hr_organization_units hou,

204:
205: -- BUG 4329611.
206: CURSOR check_org_id IS
207: SELECT mp.organization_id
208: FROM hr_organization_units hou,
209: mtl_parameters mp
210: WHERE hou.organization_id = mp.organization_id
211: AND mp.organization_id = p_org_id
212: AND trunc(sysdate) <= nvl( hou.date_to, trunc(sysdate));

Line 216: FROM hr_organization_units hou, mtl_parameters mp

212: AND trunc(sysdate) <= nvl( hou.date_to, trunc(sysdate));
213:
214: CURSOR check_org_code IS
215: SELECT mp.organization_id
216: FROM hr_organization_units hou, mtl_parameters mp
217: WHERE hou.organization_id = mp.organization_id
218: and mp.organization_code = p_org_code
219: AND trunc(sysdate) <= nvl( hou.date_to, trunc(sysdate));
220: