DBA Data[Home] [Help]

APPS.XLA_MULTIPERIOD_ACCOUNTING_PKG dependencies on DUAL

Line 601: from dual;

597: -- Set new accounting batch id.
598:
599: Select xla_accounting_batches_s.nextval
600: into g_accounting_batch_id
601: from dual;
602:
603: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
604: trace
605: (p_msg => 'g_accounting_batch_id = '||g_accounting_batch_id

Line 702: FROM DUAL;

698: DECODE(g_security_id_char_1,NULL,NULL,'and security_id_char_1 = '''||g_security_id_char_1||''' ')||
699: DECODE(g_security_id_char_2,NULL,NULL,'and security_id_char_2 = '''||g_security_id_char_2||''' ')||
700: DECODE(g_security_id_char_3,NULL,NULL,'and security_id_char_3 = '''||g_security_id_char_3||''' ')
701: INTO g_security_condition
702: FROM DUAL;
703:
704: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
705: trace
706: (p_msg => 'g_security_condition = '||g_security_condition

Line 718: FROM DUAL;

714: g_process_category_condition := NULL;
715:
716: SELECT DECODE(g_process_category_code,NULL,NULL,'and event_class_group_code = '''||g_process_category_code||'''')
717: INTO g_process_category_condition
718: FROM DUAL;
719:
720: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
721: trace
722: (p_msg => 'g_process_category_condition = '||g_process_category_condition