DBA Data[Home] [Help]

APPS.AR_ARXTDR_XMLP_PKG SQL Statements

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

Line: 11

        SELECT cp.user_concurrent_program_name
        INTO   l_report_name
        FROM   FND_CONCURRENT_PROGRAMS_VL cp,
               FND_CONCURRENT_REQUESTS cr
        WHERE  cr.request_id = P_CONC_REQUEST_ID
        AND    cp.application_id = cr.program_application_id
        AND    cp.concurrent_program_id = cr.concurrent_program_id;
Line: 36

        SELECT MEANING
        INTO   l_meaning
        FROM   AR_LOOKUPS
        WHERE  LOOKUP_TYPE = 'YES/NO'
        AND    LOOKUP_CODE = 'Y';
Line: 52

        SELECT MEANING
        INTO   l_meaning
        FROM   AR_LOOKUPS
        WHERE  LOOKUP_TYPE = 'YES/NO'
        AND    LOOKUP_CODE = 'N';
Line: 119

select language_code
into p_base_lang
from fnd_languages
where installed_flag  = 'B';