APPS.OTA_EVENT_SWI dependencies on DUAL

Line 693: FROM DUAL;

689: WHERE evt.event_id = p_event_id;
690:
691: CURSOR C_DATE IS
692: SELECT SYSDATE
693: FROM DUAL;
694:
695:
696: business_group_id hr_all_organization_units.organization_id%TYPE; --- ** Globalization changes
697:

Line 806: select to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS') into l_sysdate from dual;

802: );
803:
804: ELSE
805:
806: select to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS') into l_sysdate from dual;
807:
808: OTA_INITIALIZATION_WF.MANUAL_ENROLL_WAITLIST(
809: p_itemtype => 'OTWF',
810: p_process => 'OTA_MANUAL_ENROLL_WAITLIST',