APPS.HRI_OLTP_PMV_WRKFC_TRN_SUMMARY dependencies on FND_PROFILE

Line 41: IF fnd_profile.value('HR_TRNVR_CALC_MTHD') = 'WMV_STARTENDAVG' THEN

37: p_dynsql_rec.order_by := hri_oltp_pmv_util_pkg.set_default_order_by
38: (p_order_by_clause => p_parameter_rec.order_by);
39:
40: /* Get the profile value for the turnover calculation */
41: IF fnd_profile.value('HR_TRNVR_CALC_MTHD') = 'WMV_STARTENDAVG' THEN
42: /* Turnover lines are start/end headcount average */
43: p_dynsql_rec.hdc_trn_col_curr :=
44: 'NVL((wmv.curr_hdc_end + wmv.curr_hdc_start) / 2, 0)';
45: p_dynsql_rec.hdc_trn_col_comp :=

Line 259: IF (fnd_profile.value('HR_TRNVR_CALC_MTHD') = 'WMV_STARTENDAVG') THEN

255: l_wrkfc_fact_params.include_comp := 'Y';
256: l_wrkfc_fact_params.include_hdc := 'Y';
257: l_wrkfc_fact_params.include_sal := 'Y';
258: l_wrkfc_fact_params.bucket_dim := '';
259: IF (fnd_profile.value('HR_TRNVR_CALC_MTHD') = 'WMV_STARTENDAVG') THEN
260: l_wrkfc_fact_params.include_start := 'Y';
261: END IF;
262: l_wrkfc_fact_sql := hri_bpl_fact_sup_wrkfc_sql.get_sql
263: (p_parameter_rec => l_parameter_rec,