eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_UTILITY dependencies on BIS_LEVELS

Line 2328: l_Sql := ' SELECT COUNT(1) FROM BIS_LEVELS L, BSC_SYS_PERIODICITIES P '

2324:
2325: IF(p_Entity_Type = c_DIMENSION_OBJECT) THEN
2326:
2327: -- Check if it is associated to a Periodicity
2328: l_Sql := ' SELECT COUNT(1) FROM BIS_LEVELS L, BSC_SYS_PERIODICITIES P '
2329: || ' WHERE L.SHORT_NAME = :1 '
2330: || ' AND P.SHORT_NAME = L.SHORT_NAME ';
2331:
2332: EXECUTE IMMEDIATE l_Sql INTO l_Count USING p_Entity_Short_Name;

Line 2533: l_dim_obj_sht_name BIS_LEVELS.SHORT_NAME%TYPE;

2529: l_short_names VARCHAR2(32000);
2530: l_sql VARCHAR2(32000);
2531: l_attr2_sql VARCHAR2(32000);
2532: l_region_sht_name AK_REGIONS.REGION_CODE%TYPE;
2533: l_dim_obj_sht_name BIS_LEVELS.SHORT_NAME%TYPE;
2534: l_count NUMBER := 0;
2535: TYPE ref_cur IS REF CURSOR;
2536: c_regions_dim_obj ref_cur;
2537: BEGIN