APPS.HRI_OLTP_PMV_DTL_SALARY dependencies on HRI_MTDT_DIM_LVL

Line 66: l_column := 'geog.' || REPLACE(hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab

62: IF (l_parameter_name = 'GEOGRAPHY+COUNTRY' OR
63: l_parameter_name = 'GEOGRAPHY+AREA') THEN
64:
65: /* Form parameter condition */
66: l_column := 'geog.' || REPLACE(hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab
67: (l_parameter_name).fact_viewby_col, 'geo_');
68:
69: ELSIF (l_parameter_name = 'JOB+JOB_FAMILY' OR
70: l_parameter_name = 'JOB+JOB_FUNCTION') THEN

Line 73: l_column := 'jobh.' || hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab

69: ELSIF (l_parameter_name = 'JOB+JOB_FAMILY' OR
70: l_parameter_name = 'JOB+JOB_FUNCTION') THEN
71:
72: /* Form parameter condition */
73: l_column := 'jobh.' || hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab
74: (l_parameter_name).fact_viewby_col;
75:
76: ELSIF (l_parameter_name = 'HRI_PRFRMNC+HRI_PRFMNC_RTNG_X' OR
77: l_parameter_name = 'HRI_LOW+HRI_LOW_BAND_X') THEN

Line 80: l_column := 'asgn.' || hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab

76: ELSIF (l_parameter_name = 'HRI_PRFRMNC+HRI_PRFMNC_RTNG_X' OR
77: l_parameter_name = 'HRI_LOW+HRI_LOW_BAND_X') THEN
78:
79: /* Form parameter condition */
80: l_column := 'asgn.' || hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab
81: (l_parameter_name).fact_viewby_col;
82:
83: END IF;
84:

Line 284: 'AND sup_asg.' || hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab

280: l_parameter_name = 'HRI_LOW+HRI_LOW_BAND_X') THEN
281:
282: /* Dynamically set conditions for parameter */
283: l_where_clause := l_where_clause ||
284: 'AND sup_asg.' || hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab
285: (l_parameter_name).fact_viewby_col ||
286: ' IN (' || p_bind_tab(l_parameter_name).pmv_bind_string || ')' || g_rtn;
287:
288: END IF;

Line 547: 'AND sup_asg.' || hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab

543: l_parameter_name = 'HRI_LOW+HRI_LOW_BAND_X') THEN
544:
545: /* Dynamically set conditions for parameter */
546: l_where_clause := l_where_clause ||
547: 'AND sup_asg.' || hri_mtdt_dim_lvl.g_dim_lvl_mtdt_tab
548: (l_parameter_name).fact_viewby_col ||
549: ' IN (' || l_bind_tab(l_parameter_name).pmv_bind_string || ')' || g_rtn;
550:
551: END IF;