DBA Data[Home] [Help]

APPS.BSC_IM_UTILS dependencies on BSC_DB_CALCULATIONS

Line 35: select count(1)from bsc_db_calculations calc

31: p_fk varchar2)
32: return boolean is
33: --------------------------------------------------------------------
34: cursor cZeroCode is
35: select count(1)from bsc_db_calculations calc
36: where calc.calculation_type = 4
37: and calc.table_name =
38: (select table_name
39: from bsc_kpi_data_tables data

Line 82: select count(1) from bsc_db_calculations calc

78: where indicator = p_kpi
79: and projection_data = p_b_pt_table_name;
80: --------------------------------------------
81: cursor cZeroCode(p_sTable IN VARCHAR2) is
82: select count(1) from bsc_db_calculations calc
83: where calc.calculation_type = 4
84: and calc.table_name = p_sTable
85: and calc.parameter1 = p_fk;
86: --------------------------------------------