DBA Data[Home] [Help]

APPS.BSC_DESIGNER_PVT dependencies on BSC_SYS_FORMATS

Line 1148: BSC_SYS_FORMATS F

1144:
1145: CURSOR c_kpi_tree IS
1146: SELECT F.FORMAT,COLOR_METHOD
1147: FROM BSC_KPI_TREE_NODES_B B,
1148: BSC_SYS_FORMATS F
1149: WHERE INDICATOR = l_indicator AND NODE_ID = s_node
1150: AND F.FORMAT_ID = B.FORMAT_ID;
1151: CURSOR c_color_AO_DEFAULT IS
1152: SELECT A0_DEFAULT,A1_DEFAULT,A2_DEFAULT

Line 1158: FROM BSC_KPI_ANALYSIS_MEASURES_B B,BSC_SYS_FORMATS F,BSC_SYS_DATASETS_B DS

1154: WHERE INDICATOR = l_indicator;
1155:
1156: CURSOR c_analisys_measure IS
1157: SELECT B.SERIES_ID,F.FORMAT,DS.COLOR_METHOD
1158: FROM BSC_KPI_ANALYSIS_MEASURES_B B,BSC_SYS_FORMATS F,BSC_SYS_DATASETS_B DS
1159: WHERE INDICATOR = l_indicator
1160: AND B.ANALYSIS_OPTION0= h_a0
1161: AND B.ANALYSIS_OPTION1= h_a1
1162: AND B.ANALYSIS_OPTION2= h_a2