[Home] [Help]
41:
42: BEGIN
43: -- SELECT aggregate_by
44: -- INTO x_return_value
45: -- FROM BIM_R_CAMP_DIM_SUM_MV
46: -- WHERE rownum < 2;
47:
48: x_return_value:='QTR';
49:
85:
86: BEGIN
87: SELECT year
88: INTO x_return_value
89: FROM BIM_R_CAMP_DIM_SUM_MV
90: WHERE rownum < 2;
91:
92: RETURN (x_return_value);
93:
105:
106: BEGIN
107: SELECT qtr
108: INTO x_return_value
109: FROM BIM_R_CAMP_DIM_SUM_MV
110: WHERE rownum < 2;
111:
112: RETURN (x_return_value);
113: