DBA Data[Home] [Help]

APPS.HRI_BPL_TREND_WRKFC_ABS_SQL dependencies on FND_PROFILE

Line 133: IF ((fnd_profile.value('HR_TRNVR_CALC_MTHD') = 'WMV_STARTENDAVG') AND

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

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

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: