APPS.XLA_CREATE_ACCT_RPT_PVT SQL Statements

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

Line: 106

   SELECT decode(fnd_profile.value('AFLOG_ENABLED'), 'Y', 'Yes', 'No') INTO l_fnd_debug_status FROM dual;

Line: 114

     SELECT fnd_profile.value('USER_ID') INTO p_user_id FROM dual;

Line: 252

          SELECT application_id                   application_id
                ,application_name                 application_name
                ,:p_req_id                        request_id
            FROM fnd_application_tl
           WHERE language                = USERENV(''LANG'')
             AND application_id          = :p_application_id';

Line: 260

          SELECT fat.application_id                application_id
                ,fat.application_name              application_name
                ,:p_req_id                         request_id
            FROM fnd_application_tl      fat
           WHERE fat.language            = USERENV(''LANG'')
             AND EXISTS
                    (SELECT 1
                       FROM xla_events
                      WHERE application_id          = fat.application_id
                        AND request_id              = :p_req_id)';