DBA Data[Home] [Help]

APPS.WSH_UTIL_VALIDATE dependencies on MTL_PARAMETERS

Line 187: mtl_parameters mp

183: -- BUG 4329611.
184: CURSOR check_org_id IS
185: SELECT mp.organization_id
186: FROM hr_organization_units hou,
187: mtl_parameters mp
188: WHERE hou.organization_id = mp.organization_id
189: AND mp.organization_id = p_org_id
190: AND trunc(sysdate) <= nvl( hou.date_to, trunc(sysdate));
191:

Line 194: FROM hr_organization_units hou, mtl_parameters mp

190: AND trunc(sysdate) <= nvl( hou.date_to, trunc(sysdate));
191:
192: CURSOR check_org_code IS
193: SELECT mp.organization_id
194: FROM hr_organization_units hou, mtl_parameters mp
195: WHERE hou.organization_id = mp.organization_id
196: and mp.organization_code = p_org_code
197: AND trunc(sysdate) <= nvl( hou.date_to, trunc(sysdate));
198: