APPS.IEX_ATA_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 161

            g_user_id, g_last_update_login, g_prog_appl_id, g_prog_id,
            g_request_id, g_num_rollup_days, g_conversion_type);

Line: 231

       SELECT count(*) INTO  l_acc_count FROM jtf_tae_1600_cust_trans;

Line: 370

        SELECT fnd_concurrent_requests_s.nextval
        FROM   dual;

Line: 385

    g_last_update_login := TO_NUMBER(fnd_profile.value('CONC_LOGIN_ID'));

Line: 430

        select to_char( sysdate, 'DD-Mon-YYYY HH24:MI:SS') into l_date_str from dual;

Line: 484

        select value into s from V$PARAMETER where name = 'sort_area_size';

Line: 492

        select value into s from V$PARAMETER where name = 'hash_area_size';

Line: 534

        UPDATE JTF_TAE_1001_ACCOUNT_TRANS
            SET worker_id = mod (trans_object_id, l_ActualWorker) + 1;

Line: 536

        IEX_DEBUG('UPDATE JTF_TAE_1001_ACCOUNT_TRANS.worker_id');

Line: 538

        UPDATE JTF_TAE_1001_ACCOUNT_NM_TRANS
            SET worker_id = mod (trans_object_id, l_ActualWorker) + 1;

Line: 540

        IEX_DEBUG('UPDATE JTF_TAE_1001_ACCOUNT_NM_TRANS.worker_id');