APPS.BSC_PMF_UI_WRAPPER dependencies on BSC_KPIS_TL

Line 1076: from bsc_kpis_tl

1072: and a.tab_id = (select tab_id
1073: from bsc_tab_indicators
1074: where indicator = p_kpi_id)
1075: and a.indicator in (select indicator
1076: from bsc_kpis_tl
1077: where name = p_kpi_name);
1078:
1079: if l_count <> 0 then
1080: select d.name

Line 1083: BSC_KPIS_TL b,

1079: if l_count <> 0 then
1080: select d.name
1081: into l_tab_name
1082: from BSC_TAB_INDICATORS a,
1083: BSC_KPIS_TL b,
1084: BSC_KPIS_TL c,
1085: BSC_TABS_TL d
1086: where a.indicator = b.indicator
1087: and a.tab_id = d.tab_id

Line 1084: BSC_KPIS_TL c,

1080: select d.name
1081: into l_tab_name
1082: from BSC_TAB_INDICATORS a,
1083: BSC_KPIS_TL b,
1084: BSC_KPIS_TL c,
1085: BSC_TABS_TL d
1086: where a.indicator = b.indicator
1087: and a.tab_id = d.tab_id
1088: and b.name = c.name

Line 2499: from BSC_KPIS_TL

2495: into l_same_name
2496: from BSC_TAB_INDICATORS
2497: where tab_id = p_tab_id
2498: and indicator in (select indicator
2499: from BSC_KPIS_TL
2500: where upper(name) = upper(l_kpi_name));
2501: -- if there are kpis in this tab which have the same name it throws an error.
2502: if l_same_name <> 0 then
2503: FND_MESSAGE.SET_NAME('BSC','BSC_B_NO_SAMEKPI_TAB');