DBA Data[Home] [Help]

APPS.XLA_CREATE_ACCT_RPT_PVT SQL Statements

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

Line: 104

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

          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: 239

          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)';