APPS.BSC_PMA_DIAG_TEST SQL Statements

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

Line: 53

        JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

Line: 67

        SELECT COUNT(1) INTO h_count FROM
        v$aw_olap,all_aws,v$session
        WHERE all_aws.aw_name=bsc_aw_management.get_aw_workspace_name
        AND all_aws.aw_number=v$aw_olap.aw_number
        AND v$session.sid=v$aw_olap.session_id;

Line: 89

            sqltxt := 'SELECT * FROM bsc_tmp_opt_ui_kpis WHERE  PROCESS_ID=( SELECT TO_NUMBER(argument2) FROM '||
                      ' fnd_concurrent_requests WHERE request_id ='|| h_request_id ||' )' ;

Line: 95

            sqltxt := 'SELECT VARIABLE_ID,VALUE_N,VALUE_V FROM BSC_TMP_BIG_IN_COND WHERE VARIABLE_ID = -200 ORDER BY VALUE_N';

Line: 101

            sqltxt := 'SELECT * FROM bsc_db_loader_control WHERE  PROCESS_ID=( SELECT TO_NUMBER(argument1) FROM '||
                      ' fnd_concurrent_requests WHERE request_id ='|| h_request_id ||' )' ;