383: NVL(BTA.END_DATE(+), SYSDATE) AND
384: BK.PROTOTYPE_FLAG <> 2 AND
385: not exists (
386: SELECT BUP.INDICATOR
387: FROM BSC_USER_PARAMETERS_B BUP
388: WHERE BUP.INDICATOR = BA.INDICATOR AND
389: BUP. VIEW_TYPE = 1
390: )
391: ORDER BY BK.INDICATOR;
463: p_last_updated_by,
464: p_last_update_date,
465: p_last_updated_by,
466: p_last_updated_by
467: FROM bsc_user_parameters_b bup,
468: BSC_KPIS_B BK,
469: BSC_TAB_INDICATORS BTI,
470: BSC_USER_TAB_ACCESS BTA,
471: BSC_USER_KPI_ACCESS BA