DBA Data[Home] [Help]

APPS.HRI_BPL_TREND_TRN_SQL dependencies on FND_PROFILE

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

126: --
127: -- Format the SQL differently depending on the turnover calculation method
128: -- and whether or not snapshot MVs are available
129: --
130: IF ((fnd_profile.value('HR_TRNVR_CALC_MTHD') = 'WMV_STARTENDAVG') AND
131: NOT l_use_snapshot) THEN
132:
133: -- Start/end average required, no snapshots available
134: -- SQL returned needs to join to workforce fact twice to get the

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

174: AND wmv.period_as_of_date = wmv_start.period_as_of_date (+)';
175:
176: ELSE
177:
178: IF (fnd_profile.value('HR_TRNVR_CALC_MTHD') = 'WMV_STARTENDAVG') THEN
179:
180: -- Snapshot fact available
181: -- Period Headcount start/end included in single snapshot
182: