APPS.OTA_EVENT_SWI dependencies on DUAL

Line 697: FROM DUAL;

693: WHERE evt.event_id = p_event_id;
694:
695: CURSOR C_DATE IS
696: SELECT SYSDATE
697: FROM DUAL;
698:
699:
700: business_group_id hr_all_organization_units.organization_id%TYPE; --- ** Globalization changes
701:

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

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