APPS.FII_SNAP_TBL_REFRESH dependencies on BIS_SYSTEM_DATE

Line 122: g_phase := 'Populate l_this_date FROM BIS_SYSTEM_DATE';

118: -- Find out if this is commercial or government install
119: g_phase := 'Find out if this is commercial or government install';
120: l_industry_pf := FND_PROFILE.value('INDUSTRY');
121:
122: g_phase := 'Populate l_this_date FROM BIS_SYSTEM_DATE';
123:
124: --We use a un-shipped profile option FII_TEST_SYSDATE ("FII: Test Sysdate")
125: --to reset different sysdate so that we can test for snapshot tables.
126: if g_test_sysdate is NULL THEN

Line 128: FROM BIS_SYSTEM_DATE;

124: --We use a un-shipped profile option FII_TEST_SYSDATE ("FII: Test Sysdate")
125: --to reset different sysdate so that we can test for snapshot tables.
126: if g_test_sysdate is NULL THEN
127: SELECT trunc(CURRENT_DATE_ID) INTO l_this_date
128: FROM BIS_SYSTEM_DATE;
129: ELSE
130: l_this_date := g_test_sysdate;
131: end if;
132:

Line 1099: g_phase := 'Populate l_this_date FROM BIS_SYSTEM_DATE';

1095: FII_UTIL.Write_Log ('> Entering REFRESH_GL_LOCAL_SNAP_F');
1096: FII_UTIL.start_timer();
1097: END IF;
1098:
1099: g_phase := 'Populate l_this_date FROM BIS_SYSTEM_DATE';
1100:
1101: --We use a un-shipped profile option FII_TEST_SYSDATE ("FII: Test Sysdate")
1102: --to reset different sysdate so that we can test for snapshot tables.
1103: if g_test_sysdate is NULL THEN

Line 1105: FROM BIS_SYSTEM_DATE;

1101: --We use a un-shipped profile option FII_TEST_SYSDATE ("FII: Test Sysdate")
1102: --to reset different sysdate so that we can test for snapshot tables.
1103: if g_test_sysdate is NULL THEN
1104: SELECT trunc(CURRENT_DATE_ID) INTO l_this_date
1105: FROM BIS_SYSTEM_DATE;
1106: ELSE
1107: l_this_date := g_test_sysdate;
1108: end if;
1109: ---------------------------------------------------------