APPS.HRI_BPL_TREND_ABS_SQL dependencies on HRI_MTDT_DIM_LVL

Line 101: 'AND fact.' || hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab

97: IF (l_parameter_name = 'HRI_ABSNC+HRI_ABSNC_CAT' ) THEN
98:
99: /* Dynamically set conditions for parameter */
100: p_fact_conditions := p_fact_conditions ||
101: 'AND fact.' || hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab
102: (l_parameter_name).fact_viewby_col ||
103: ' IN (' || p_bind_tab(l_parameter_name).pmv_bind_string || ')' || g_rtn;
104:
105: /* Keep count of parameters set */

Line 138: l_bucket_tab hri_mtdt_dim_lvl.dim_lvl_buckets_tabtype;

134:
135: -- template
136: l_column_bucket VARCHAR2(1000);
137: -- table of bucket values
138: l_bucket_tab hri_mtdt_dim_lvl.dim_lvl_buckets_tabtype;
139: --
140: -- For forming the select statement
141: --
142: l_measure_abs_drtn_days VARCHAR2(1000);

Line 160: l_bucket_tab := hri_mtdt_dim_lvl.g_abs_category_buckets_tab;

156: l_measure_abs_drtn_ntf_prd := 'fact.abs_ntfctn_days_start_blnc + fact.abs_ntfctn_days_nstart_blnc';
157:
158: -- Get a pl/sql table containing the buckets for the given bucket dimension
159: IF (p_bucket_dim = 'HRI_ABSNC+HRI_ABSNC_CAT') THEN
160: l_bucket_tab := hri_mtdt_dim_lvl.g_abs_category_buckets_tab;
161: END IF;
162:
163: -- Set measure columns for Absence Duration Days
164: IF (p_include_abs_drtn_days ='Y') THEN

Line 175: hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab

171: IF p_bucket_dim IS NOT NULL THEN
172:
173: -- Set the bucket column template to use the bucket column
174: l_column_bucket := REPLACE(g_column_bucket, '',
175: hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab
176: (p_bucket_dim).fact_viewby_col);
177:
178:
179: /* Loop through bucket ids to add required columns */

Line 207: hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab

203: IF p_bucket_dim IS NOT NULL THEN
204:
205: -- Set the bucket column template to use the bucket column
206: l_column_bucket := REPLACE(g_column_bucket, '',
207: hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab
208: (p_bucket_dim).fact_viewby_col);
209:
210: /* Loop through bucket ids to add required columns */
211: FOR i IN l_bucket_tab.FIRST..l_bucket_tab.LAST LOOP