APPS.HRI_BPL_FACT_ABS_SQL dependencies on HRI_MTDT_DIM_LVL

Line 218: 'AND absn.' || hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab

214: l_parameter_name = 'HRI_ABSNC+HRI_ABSNC_CAT') THEN
215:
216: /* Dynamically set conditions for parameter */
217: p_fact_conditions := p_fact_conditions ||
218: 'AND absn.' || hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab
219: (l_parameter_name).fact_viewby_col ||
220: ' IN (' || p_bind_tab(l_parameter_name).pmv_bind_string || ')' || g_rtn;
221:
222: /* Keep count of parameters set */

Line 380: l_bucket_tab hri_mtdt_dim_lvl.dim_lvl_buckets_tabtype;

376: /* Return string */
377: l_column_list VARCHAR2(5000);
378:
379: /* Table of buckets for the given bucket dimension */
380: l_bucket_tab hri_mtdt_dim_lvl.dim_lvl_buckets_tabtype;
381:
382: /* Column Templates */
383: l_bucket_column VARCHAR2(1000);
384:

Line 619: ' || hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab

615: /**************************/
616:
617: l_fact_sql :=
618: 'SELECT /*+ NO_MERGE INDEX(absn) */
619: ' || hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab
620: (p_parameter_rec.view_by).fact_viewby_col || ' vby_id
621: ,' || l_direct_ind || ' direct_ind ' || g_rtn ||
622: l_col_list ||
623: 'FROM' || g_rtn ||

Line 629: ' || hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab

625: p_fact_conditions ||
626: l_date_condition ||
627: l_snapshot_condition ||
628: 'GROUP BY
629: ' || hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab
630: (p_parameter_rec.view_by).fact_viewby_col || g_rtn ||
631: ',' || l_direct_ind;
632:
633: RETURN l_fact_sql;