DBA Data[Home] [Help]

APPS.HRI_OLTP_PMV_ABS_WMV_PVT dependencies on FND_PROFILE

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

421: l_abs_fact_params.include_abs_drtn_days := 'Y';
422: END IF;
423:
424: /* Format the SQL differently depending on the headcount calculation method */
425: IF (fnd_profile.value('HR_TRNVR_CALC_MTHD') = 'WMV_STARTENDAVG') THEN
426: l_dynmc_hdc_curr := 'NVL((babs.curr_hdc_start + babs.curr_hdc_end)/2,0)';
427: l_dynmc_hdc_comp := 'NVL((babs.comp_hdc_start + babs.comp_hdc_end)/2,0)';
428: l_dynmc_tot_hdc_curr := 'NVL((babs.tot_curr_hdc_start + babs.tot_curr_hdc_end)/2,0)';
429: l_dynmc_tot_hdc_comp := 'NVL((babs.tot_comp_hdc_start + babs.tot_comp_hdc_end)/2,0)';