APPS.HRI_OLTP_PMV_WMV_TRN_SUP dependencies on FND_PROFILE

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

72: p_parameter_rec => l_parameter_rec,
73: p_bind_tab => l_bind_tab);
74:
75: /* Turnover calculation method is either start/end average or end value */
76: IF (fnd_profile.value('HR_TRNVR_CALC_MTHD') = 'WMV_STARTENDAVG') THEN
77:
78: /* Set Column Strings */
79: l_col_curr_trn_hdc := '(wmv.curr_hdc_end + wmv.curr_hdc_start) / 2';
80: l_col_comp_trn_hdc := '(wmv.comp_hdc_end + wmv.comp_hdc_start) / 2';

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

398: p_parameter_rec => l_parameter_rec,
399: p_bind_tab => l_bind_tab);
400:
401: /* Turnover calculation method is either start/end average or end value */
402: IF (fnd_profile.value('HR_TRNVR_CALC_MTHD') = 'WMV_STARTENDAVG') THEN
403:
404: /* Set Column Strings */
405: l_col_curr_trn_hdc := '(wmv.curr_hdc_end + wmv.curr_hdc_start) / 2';
406: l_col_curr_tot_trn_hdc := '(wmv.curr_hdc_end + wmv.curr_total_hdc_start) / 2';

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

1047: -- bug 4294146
1048: -- Check the Turnover Profile option and change dynamic calculations
1049: -- columns in the report SQL statement
1050: --
1051: IF fnd_profile.value('HR_TRNVR_CALC_MTHD') = 'WMV_STARTENDAVG' THEN
1052: -- use average turnover headcount calculation method
1053: l_curr_hdc_end_col := '((hdc.curr_hdc_start+hdc.curr_hdc_end)/2)';
1054: l_comp_hdc_end_col := '((hdc.comp_hdc_start+hdc.comp_hdc_end)/2)';
1055: