DBA Data[Home] [Help]

APPS.XLA_MULTIPERIOD_ACCOUNTING_PKG dependencies on DUAL

Line 585: from dual;

581: -- Set new accounting batch id.
582:
583: Select xla_accounting_batches_s.nextval
584: into g_accounting_batch_id
585: from dual;
586:
587: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
588: trace
589: (p_msg => 'g_accounting_batch_id = '||g_accounting_batch_id

Line 684: FROM DUAL;

680: DECODE(g_security_id_char_1,NULL,NULL,'and security_id_char_1 = '''||g_security_id_char_1||''' ')||
681: DECODE(g_security_id_char_2,NULL,NULL,'and security_id_char_2 = '''||g_security_id_char_2||''' ')||
682: DECODE(g_security_id_char_3,NULL,NULL,'and security_id_char_3 = '''||g_security_id_char_3||''' ')
683: INTO g_security_condition
684: FROM DUAL;
685:
686: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
687: trace
688: (p_msg => 'g_security_condition = '||g_security_condition

Line 700: FROM DUAL;

696: g_process_category_condition := NULL;
697:
698: SELECT DECODE(g_process_category_code,NULL,NULL,'and event_class_group_code = '''||g_process_category_code||'''')
699: INTO g_process_category_condition
700: FROM DUAL;
701:
702: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
703: trace
704: (p_msg => 'g_process_category_condition = '||g_process_category_condition