APPS.WIP_JOB_DTLS_VALIDATIONS dependencies on FND_USER_VIEW

Line 459: from fnd_user_view fu

455: wip_constants.warning)
456: and wjdi.wip_entity_id = p_wip_entity_id
457: and wjdi.organization_id = p_organization_id
458: and not exists (select 1
459: from fnd_user_view fu
460: where fu.user_id = wjdi.last_updated_by
461: and sysdate between fu.start_date and nvl(fu.end_date,sysdate+1));
462:
463: l_error_exists boolean := false;

Line 493: from fnd_user_view fu

489: wip_constants.warning)
490: and wip_entity_id = p_wip_entity_id
491: and organization_id = p_organization_id
492: and not exists (select 1
493: from fnd_user_view fu
494: where fu.user_id = wjdi.last_updated_by
495: and sysdate between fu.start_date and nvl(fu.end_date,sysdate+1));
496: end if;
497: end last_updated_by;

Line 514: from fnd_user_view fu

510: wip_constants.warning)
511: and wjdi.wip_entity_id = p_wip_entity_id
512: and wjdi.organization_id = p_organization_id
513: and not exists (select 1
514: from fnd_user_view fu
515: where fu.user_id = wjdi.created_by
516: and sysdate between fu.start_date and nvl(fu.end_date,sysdate+1));
517:
518: l_error_exists boolean := false;

Line 548: from fnd_user_view fu

544: wip_constants.warning)
545: and wip_entity_id = p_wip_entity_id
546: and organization_id = p_organization_id
547: and not exists (select 1
548: from fnd_user_view fu
549: where fu.user_id = wjdi.created_by
550: and sysdate between fu.start_date and nvl(fu.end_date,sysdate+1));
551: end if;
552: end created_by;