129: --
130: -- Format the SQL differently depending on the turnover calculation method
131: -- and whether or not snapshot MVs are available
132: --
133: IF ((fnd_profile.value('HR_TRNVR_CALC_MTHD') = 'WMV_STARTENDAVG') AND
134: NOT l_use_snapshot) THEN
135:
136: -- Start/end average required, no snapshots available
137: -- SQL returned needs to join to workforce fact twice to get the
177: AND wmv.period_as_of_date = wmv_start.period_as_of_date (+)';
178:
179: ELSE
180:
181: IF (fnd_profile.value('HR_TRNVR_CALC_MTHD') = 'WMV_STARTENDAVG') THEN
182:
183: -- Snapshot fact available
184: -- Period Headcount start/end included in single snapshot
185: