[Home] [Help]
42: SELECT k.RESPONSIBILITY_ID,
43: bt.TAB_ID,
44: k.INDICATOR
45: FROM BSC_USER_KPIGRAPH_PLUGS k,
46: BSC_TAB_INDICATORS bt
47: WHERE k.USER_ID = l_user_id
48: AND k.PLUG_ID = p_plug_id
49: AND k.INDICATOR = bt.INDICATOR;
50:
60:
61: CURSOR c_tab_kpi IS
62: SELECT bt.TAB_ID
63: FROM BSC_USER_KPIGRAPH_PLUGS k,
64: BSC_TAB_INDICATORS bt
65: WHERE k.USER_ID = l_user_id
66: AND k.PLUG_ID = p_plug_id
67: AND k.INDICATOR = bt.INDICATOR;
68:
204: fnd_user_resp_groups fg,
205: fnd_responsibility fr,
206: bsc_user_responsibility_v br,
207: bsc_user_kpigraph_plugs bp,
208: bsc_tab_indicators bti,
209: bsc_user_tab_access bta,
210: bsc_user_kpi_access bk
211: WHERE
212: bp.PLUG_ID = p_plug_id AND
901: SELECT k.RESPONSIBILITY_ID,
902: bt.TAB_ID,
903: k.INDICATOR
904: FROM BSC_USER_KPIGRAPH_PLUGS k,
905: BSC_TAB_INDICATORS bt
906: WHERE k.USER_ID = l_user_id
907: AND k.PLUG_ID = p_plug_id
908: AND k.INDICATOR = bt.INDICATOR;
909:
1087:
1088:
1089: CURSOR c_tab IS
1090: SELECT bt.TAB_ID
1091: FROM bsc_tab_indicators bt
1092: WHERE
1093: bt.INDICATOR = p_kpi_id;
1094:
1095: