DBA Data[Home] [Help]

APPS.BSC_BIS_MEASURE_PUB dependencies on BSC_SYS_DATASET_CALC

Line 3676: from bsc_sys_dataset_calc

3672:
3673: if(p_is_ytd_enabled is not null) then
3674: select decode(count(disabled_calc_id), 1, 'N', 0, 'Y', 'N') isDisabled
3675: into l_is_ytd_enabled
3676: from bsc_sys_dataset_calc
3677: where dataset_id = p_dataset_id
3678: and disabled_calc_id = c_YTD_CODE;
3679: end if;
3680:

Line 3684: from bsc_sys_dataset_calc

3680:
3681: if(p_is_qtd_enabled is not null) then
3682: select decode(count(disabled_calc_id), 1, 'N', 0, 'Y', 'N') isDisabled
3683: into l_is_qtd_enabled
3684: from bsc_sys_dataset_calc
3685: where dataset_id = p_dataset_id
3686: and disabled_calc_id = c_QTD_CODE;
3687: end if;
3688:

Line 3693: from bsc_sys_dataset_calc

3689: -- needed for XTD Enhancement
3690: if(p_is_xtd_enabled is not null) then
3691: select decode(count(disabled_calc_id), 1, 'N', 0, 'Y', 'N') isDisabled
3692: into l_is_xtd_enabled
3693: from bsc_sys_dataset_calc
3694: where dataset_id = p_dataset_id
3695: and disabled_calc_id = c_XTD_CODE;
3696: end if;
3697: