572: -- l_sort_date will have value 'GL_DATE', 'REFERENCE_DATE' or 'COMPLETION_DATE'
573: IF(l_gl_seq_status = 'SUCCESS') THEN
574: SELECT nvl(SORT_OPTION, DATE_TYPE)
575: INTO l_sort_date
576: FROM FUN_SEQ_CONTEXTS
577: WHERE SEQ_CONTEXT_ID = l_gl_seq_context_id;
578: ELSE
579: SELECT nvl(SORT_OPTION, DATE_TYPE)
580: INTO l_sort_date
577: WHERE SEQ_CONTEXT_ID = l_gl_seq_context_id;
578: ELSE
579: SELECT nvl(SORT_OPTION, DATE_TYPE)
580: INTO l_sort_date
581: FROM FUN_SEQ_CONTEXTS
582: WHERE SEQ_CONTEXT_ID = l_xla_seq_context_id;
583: END IF;
584:
585: IF (C_LEVEL_STATEMENT>= g_log_level) THEN
874: -- l_sort_date will have value 'GL_DATE', 'REFERENCE_DATE' or 'COMPLETION_DATE'
875: IF(l_gl_seq_status = 'SUCCESS') THEN
876: SELECT nvl(SORT_OPTION, DATE_TYPE)
877: INTO l_sort_date
878: FROM FUN_SEQ_CONTEXTS
879: WHERE SEQ_CONTEXT_ID = l_gl_seq_context_id;
880: ELSE
881: SELECT nvl(SORT_OPTION, DATE_TYPE)
882: INTO l_sort_date
879: WHERE SEQ_CONTEXT_ID = l_gl_seq_context_id;
880: ELSE
881: SELECT nvl(SORT_OPTION, DATE_TYPE)
882: INTO l_sort_date
883: FROM FUN_SEQ_CONTEXTS
884: WHERE SEQ_CONTEXT_ID = l_xla_seq_context_id;
885: END IF;
886:
887: IF (C_LEVEL_STATEMENT>= g_log_level) THEN