APPS.HRI_OLTP_PMV_WMV_ABS_SUP_GRAPH dependencies on HRI_BPL_UTILIZATION

Line 67: IF (hri_bpl_utilization.get_abs_durtn_profile_vl = 'DAYS') THEN

63: l_trend_sql_params.include_hdc := 'Y';
64: l_trend_sql_params.include_abs_in_period := 'Y';
65:
66: /* Set metric base on absence UOM profile option, default to DAYS */
67: IF (hri_bpl_utilization.get_abs_durtn_profile_vl = 'DAYS') THEN
68: l_trend_sql_params.include_abs_drtn_days := 'Y';
69:
70: l_period_abs_drtn_metric1 :=
71: 'DECODE(qry.period_hdc_abs, 0, to_number(NULL), (qry.period_abs_drtn_days/qry.period_hdc_abs))';

Line 74: ELSIF (hri_bpl_utilization.get_abs_durtn_profile_vl = 'HOURS') THEN

70: l_period_abs_drtn_metric1 :=
71: 'DECODE(qry.period_hdc_abs, 0, to_number(NULL), (qry.period_abs_drtn_days/qry.period_hdc_abs))';
72: l_period_abs_drtn_metric2 := 'qry.period_abs_drtn_days';
73:
74: ELSIF (hri_bpl_utilization.get_abs_durtn_profile_vl = 'HOURS') THEN
75: l_trend_sql_params.include_abs_drtn_hrs := 'Y';
76: l_period_abs_drtn_metric1 :=
77: 'DECODE(qry.period_hdc_abs, 0, to_number(NULL), (qry.period_abs_drtn_hrs/qry.period_hdc_abs))';
78: l_period_abs_drtn_metric2 := 'qry.period_abs_drtn_hrs';