DBA Data[Home] [Help]

APPS.HRI_OPL_DBI_SENIOR_MGR dependencies on FND_PROFILE

Line 25: IF (fnd_profile.value('HRI_DBI_PER_SNRMGR_SNPSHTS') = 'Y') THEN

21: EXECUTE IMMEDIATE(l_sql_stmt);
22: END IF;
23:
24: /* If snapshots are enabled then reload the tables */
25: IF (fnd_profile.value('HRI_DBI_PER_SNRMGR_SNPSHTS') = 'Y') THEN
26:
27: /* Get threshold from profile option */
28: l_senior_mgr_threshold := fnd_profile.value('HRI_DBI_PER_SNRMGR_THRSHLD');
29:

Line 28: l_senior_mgr_threshold := fnd_profile.value('HRI_DBI_PER_SNRMGR_THRSHLD');

24: /* If snapshots are enabled then reload the tables */
25: IF (fnd_profile.value('HRI_DBI_PER_SNRMGR_SNPSHTS') = 'Y') THEN
26:
27: /* Get threshold from profile option */
28: l_senior_mgr_threshold := fnd_profile.value('HRI_DBI_PER_SNRMGR_THRSHLD');
29:
30: /* Default the value if the profile option is not populated */
31: IF (l_senior_mgr_threshold IS NULL) THEN
32: l_senior_mgr_threshold := 2500;