APPS.ISC_DBI_TS_ARR_PERF_TR_PKG SQL Statements

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

Line: 193

     Description:   builds the outer select clause
    ---------------------------------------------------*/

    FUNCTION get_trd_sel_clause (p_view_by_dim IN VARCHAR2)
        RETURN VARCHAR2
    IS
        l_sel_clause varchar2(7500);

Line: 205

        'SELECT
            ' || ' cal_name VIEWBY,
                   nvl(c_ot_arrivals,0) 		ISC_MEASURE_1,
            ' || isc_dbi_sutil_pkg.rate_str (
                    p_numerator     => 'c_ot_arrivals',
                    p_denominator   => 'c_stop_arrivals',
                    p_rate_type     => 'PERCENT',
                    p_measure_name  => 'ISC_MEASURE_2') || ', -- OT Arrival Rate
                   nvl(c_late_arrivals,0) 		ISC_MEASURE_3,
            ' || isc_dbi_sutil_pkg.rate_str (
                    p_numerator     => 'c_late_arrivals',
                    p_denominator   => 'c_stop_arrivals',
                    p_rate_type     => 'PERCENT',
                    p_measure_name  => 'ISC_MEASURE_4') || ', -- Late Arrival Rate
                   nvl(c_early_arrivals,0) 		ISC_MEASURE_5,
            ' || isc_dbi_sutil_pkg.rate_str (
                    p_numerator     => 'c_early_arrivals',
                    p_denominator   => 'c_stop_arrivals',
                    p_rate_type     => 'PERCENT',
                    p_measure_name  => 'ISC_MEASURE_6') || ', -- Early Arrival Rate
                   nvl(c_stop_arrivals,0) 		ISC_MEASURE_7,
                   nvl(c_plan_arrivals,0) 		ISC_MEASURE_8,
            ' || isc_dbi_sutil_pkg.rate_str (
                    p_numerator     => 'c_stop_arrivals',
                    p_denominator   => 'c_plan_arrivals',
                    p_rate_type     => 'PERCENT',
                    p_measure_name  => 'ISC_MEASURE_9'); -- Trip Stop Arrivals to Plan