DBA Data[Home] [Help]

APPS.EAM_WO_CHANGE_STATUS_PVT dependencies on DUAL

Line 629: FROM DUAL

625: -- Bug # 4862404 : Replace eam_direct_item_recs_v by base table
626:
627: BEGIN
628: SELECT 1 INTO l_di_count
629: FROM DUAL
630: WHERE EXISTS
631: (
632: SELECT 1
633: FROM wip_eam_direct_items wedi

Line 836: FROM dual;

832: BEGIN
833: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_WO_CHANGE_STATUS_PVT.change_status: Selecting group_id'); END IF;
834: SELECT wip_dj_close_temp_s.nextval
835: INTO l_gid
836: FROM dual;
837: EXCEPTION
838: WHEN OTHERS THEN
839: raise fnd_api.g_exc_unexpected_error;
840: END;