DBA Data[Home] [Help]

APPS.BSC_PMF_UI_WRAPPER dependencies on BSC_KPI_ANALYSIS_OPTIONS_B

Line 1871: from BSC_KPI_ANALYSIS_OPTIONS_B

1867:
1868: -- obtain dimension set id this option is using.
1869: select dim_set_id
1870: into l_dim_set_id
1871: from BSC_KPI_ANALYSIS_OPTIONS_B
1872: where indicator = p_kpi_id
1873: and analysis_group_id = p_option_group_id
1874: and option_id = p_option_id;
1875:

Line 1900: from BSC_KPI_ANALYSIS_OPTIONS_B

1896:
1897: -- Determine if the dimension set is being used by other options.
1898: select count(option_id)
1899: into l_count
1900: from BSC_KPI_ANALYSIS_OPTIONS_B
1901: where indicator = p_kpi_id
1902: and dim_set_id = l_dim_set_id;
1903:
1904: -- If there are no more options using this dim set delete it.

Line 3560: from BSC_KPI_ANALYSIS_OPTIONS_B

3556:
3557: -- Evaluate if the option exists
3558: select count(option_id)
3559: into l_count
3560: from BSC_KPI_ANALYSIS_OPTIONS_B
3561: where indicator = p_kpi_id
3562: and analysis_group_id = p_analysis_group_id
3563: and option_id = p_option_id
3564: and parent_option_id = p_parent_option_id

Line 3614: from BSC_KPI_ANALYSIS_OPTIONS_B

3610:
3611: -- Evaluate if the Analysis option Exist in the Metadata
3612: select count(option_id)
3613: into l_count
3614: from BSC_KPI_ANALYSIS_OPTIONS_B
3615: where indicator = p_kpi_id
3616: and analysis_group_id = p_analysis_group_id
3617: and option_id = p_option_id
3618: and parent_option_id = p_parent_option_id