APPS.XLA_HIST_LEDGER_UPG_PKG dependencies on DUAL

Line 788: SELECT xla_accounting_batches_s.NEXTVAL INTO g_sec_alc_min_acctng_batch_id FROM DUAL;

784:
785:
786: -- added by vgopiset
787: IF g_sec_alc_min_acctng_batch_id IS NULL THEN
788: SELECT xla_accounting_batches_s.NEXTVAL INTO g_sec_alc_min_acctng_batch_id FROM DUAL;
789: END IF;
790:
791:
792: ELSIF g_success_runs > 0 THEN

Line 843: FROM DUAL

839: BEGIN -- Check if all fully accounted data has also been transferred to GL
840:
841: SELECT 1
842: INTO g_untransferred_headers
843: FROM DUAL
844: WHERE EXISTS (SELECT /*+ parallel (xla_ae_headers) */ 1
845: FROM xla_ae_headers
846: WHERE ledger_id = g_primary_ledger_id
847: AND accounting_entry_status_code = 'F'

Line 918: SELECT xla_upg_batches_s.NEXTVAL INTO g_upgrade_id FROM DUAL;

914:
915:
916: -- g_upgrade_id := fnd_global.conc_request_id(); commented out
917:
918: SELECT xla_upg_batches_s.NEXTVAL INTO g_upgrade_id FROM DUAL;
919: g_script_name := 'xlahupg_' || g_upgrade_id;
920:
921: --g_sec_alc_end_date: set in validate_final_mode
922:

Line 1067: FROM DUAL

1063:
1064: BEGIN
1065: SELECT 1
1066: INTO g_alc_exists
1067: FROM DUAL
1068: WHERE EXISTS (SELECT 1
1069: FROM xla_subledgers
1070: WHERE alc_enabled_flag = 'Y'
1071: AND application_id = g_application_id);

Line 1338: FROM DUAL

1334: BEGIN
1335:
1336: SELECT 1
1337: INTO g_rate_exists
1338: FROM DUAL
1339: WHERE EXISTS (SELECT 1
1340: FROM xla_rc_upgrade_rates
1341: WHERE relationship_id = g_relationship_id
1342: AND upgrade_run_id = g_upgrade_id);