APPS.HRI_OLTP_PMV_ABS_DTL dependencies on HRI_MTDT_DIM_LVL

Line 10: hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab('HRI_ABSNC+HRI_ABSNC_CAT').viewby_table;

6:
7: g_unassigned VARCHAR2(50) := HRI_OLTP_VIEW_MESSAGE.get_unassigned_msg;
8:
9: g_abs_cat_cl_view VARCHAR2(30) :=
10: hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab('HRI_ABSNC+HRI_ABSNC_CAT').viewby_table;
11: g_abs_rsn_cl_view VARCHAR2(30) :=
12: hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab('HRI_ABSNC+HRI_ABSNC_RSN').viewby_table;
13: g_abs_per_per_cl_view VARCHAR2(30) := 'hri_dbi_cl_per_n_v';
14: g_abs_per_sup_cl_view VARCHAR2(30) := 'hri_dbi_cl_per_n_v';

Line 12: hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab('HRI_ABSNC+HRI_ABSNC_RSN').viewby_table;

8:
9: g_abs_cat_cl_view VARCHAR2(30) :=
10: hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab('HRI_ABSNC+HRI_ABSNC_CAT').viewby_table;
11: g_abs_rsn_cl_view VARCHAR2(30) :=
12: hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab('HRI_ABSNC+HRI_ABSNC_RSN').viewby_table;
13: g_abs_per_per_cl_view VARCHAR2(30) := 'hri_dbi_cl_per_n_v';
14: g_abs_per_sup_cl_view VARCHAR2(30) := 'hri_dbi_cl_per_n_v';
15:
16: /******************************************************************************/

Line 65: 'AND abs_cs.' || hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab

61: IF (l_parameter_name = 'HRI_ABSNC+HRI_ABSNC_CAT' ) THEN
62:
63: /* Dynamically set conditions for parameter */
64: l_where_clause := l_where_clause ||
65: 'AND abs_cs.' || hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab
66: (l_parameter_name).fact_viewby_col ||
67: ' IN (' || p_bind_tab(l_parameter_name).pmv_bind_string || ')' || g_rtn;
68:
69: END IF;

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

213: IF (l_parameter_name = 'HRI_ABSNC+HRI_ABSNC_CAT' ) THEN
214:
215: /* Dynamically set conditions for parameter */
216: l_where_clause := l_where_clause ||
217: 'AND fact.' || hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab
218: (l_parameter_name).fact_viewby_col ||
219: ' IN (' || p_bind_tab(l_parameter_name).pmv_bind_string || ')' || g_rtn;
220:
221: END IF;