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
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: --------------------------------------------