DBA Data[Home] [Help]

APPS.EAM_ASSETNUMBER_PUB dependencies on DUAL

Line 901: FROM DUAL

897: /* Bug # 4768635 : Validate if Maintainable)_flag can be 'N' */
898: IF (p_maintainable_flag = 'N' AND l_old_maint_flag = 'Y') THEN
899: BEGIN
900: SELECT 1 INTO l_count
901: FROM DUAL
902: WHERE EXISTS
903: (SELECT wdj.wip_entity_id
904: FROM wip_discrete_jobs wdj
905: WHERE wdj.status_type not in (4, 5, 7, 12)