APPS.BSC_INVALID_DIM_LVLS_RPT dependencies on BSC_SYS_DIM_LEVELS_B

Line 42: h_source bsc_sys_dim_levels_b.source%TYPE;

38: sqltxt VARCHAR2 (2000);
39: h_headers JTF_DIAGNOSTIC_COREAPI.headers;
40: h_lengths JTF_DIAGNOSTIC_COREAPI.lengths;
41: h_count NUMBER;
42: h_source bsc_sys_dim_levels_b.source%TYPE;
43: h_pmf_count NUMBER;
44: h_bsc_count NUMBER;
45: CURSOR cv IS
46: SELECT source,COUNT(short_name) FROM bsc_sys_dim_levels_vl