APPS.CSE_GL_INTERFACE_PKG dependencies on DUAL

Line 383: SELECT SYSDATE INTO l_sysdate FROM DUAL ;

379: xla_security_pkg.set_security_context(p_application_id => l_application_id );
380:
381: l_debug := NVL(fnd_profile.value('CSE_DEBUG_OPTION'),'N');
382:
383: SELECT SYSDATE INTO l_sysdate FROM DUAL ;
384:
385: BEGIN
386: -- IF (l_debug = 'Y') THEN
387: cse_debug_pub.g_dir := nvl(FND_PROFILE.VALUE('CSE_DEBUG_LOG_DIRECTORY'), '/tmp');

Line 676: SELECT GL_INTERFACE_CONTROL_S.NEXTVAL INTO l_gl_group_id FROM DUAL ;

672: AND rownum = 1 ;
673:
674: IF i = 1
675: THEN
676: SELECT GL_INTERFACE_CONTROL_S.NEXTVAL INTO l_gl_group_id FROM DUAL ;
677: END IF ;
678:
679:
680: IF (l_debug = 'Y')