APPS.HRI_OLTP_PMV_WMV_TRN_SUMMRY dependencies on FND_PROFILE

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

37:
38: BEGIN
39:
40: /* Get the profile value for the turnover calculation */
41: IF fnd_profile.value('HR_TRNVR_CALC_MTHD') = 'WMV_STARTENDAVG' THEN
42: /* Set the current calculation to be current start/end 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 229: IF (fnd_profile.value('HR_TRNVR_CALC_MTHD') = 'WMV_STARTENDAVG') THEN

225: /* Generate the Workforce Fact SQL */
226: l_wrkfc_params.bind_format := 'PMV';
227: l_wrkfc_params.include_hdc := 'Y';
228: l_wrkfc_params.include_comp := 'Y';
229: IF (fnd_profile.value('HR_TRNVR_CALC_MTHD') = 'WMV_STARTENDAVG') THEN
230: l_wrkfc_params.include_start := 'Y';
231: END IF;
232: l_wrkfc_fact_sql := hri_bpl_fact_sup_wrkfc_sql.get_sql
233: (p_parameter_rec => l_parameter_rec,