DBA Data[Home] [Help]

APPS.AP_ACCTG_DATA_FIX_PKG dependencies on DUAL

Line 34: FROM DUAL;

30:
31: BEGIN
32: SELECT TO_CHAR(SYSDATE, '-HH24:MI:SS')
33: INTO l_date
34: FROM DUAL;
35:
36: l_log_file := p_bug_number||l_date||'.html';
37: l_out_file := p_bug_number||'.out';
38:

Line 781: FROM dual

777: l_dummy := 0;
778:
779: SELECT 1
780: INTO l_dummy
781: FROM dual
782: WHERE EXISTS
783: (SELECT 1
784: FROM xla_events xe
785: WHERE xe.application_id = 200

Line 926: FROM dual

922: l_debug_info := 'Checking if journals exist..';
923:
924: SELECT 'Y'
925: INTO l_journals_exist
926: FROM dual
927: WHERE EXISTS
928: (SELECT 'JOURNALS EXISTS'
929: FROM xla_ae_headers
930: WHERE application_id =200

Line 1010: FROM dual

1006: l_dummy := 0;
1007:
1008: SELECT 1
1009: INTO l_dummy
1010: FROM dual
1011: WHERE EXISTS
1012: (SELECT 1
1013: FROM xla_transaction_entities_upg xte
1014: WHERE xte.application_id = 200