DBA Data[Home] [Help]

APPS.FII_AR_TPDUE_TBL_REFRESH dependencies on BIS_SYSTEM_DATE

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

114: FII_UTIL.start_timer();
115: END IF;
116:
117:
118: g_phase := 'Populate l_this_date FROM BIS_SYSTEM_DATE';
119:
120: --We use a un-shipped profile option FII_TEST_SYSDATE ("FII: Test Sysdate")
121: --to reset different sysdate so that we can test for snapshot tables.
122: if g_test_sysdate is NULL THEN

Line 124: FROM BIS_SYSTEM_DATE;

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

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

450: FII_UTIL.start_timer();
451: END IF;
452:
453:
454: g_phase := 'Populate l_this_date FROM BIS_SYSTEM_DATE';
455:
456: --We use a un-shipped profile option FII_TEST_SYSDATE ("FII: Test Sysdate")
457: --to reset different sysdate so that we can test for snapshot tables.
458: if g_test_sysdate is NULL THEN

Line 460: FROM BIS_SYSTEM_DATE;

456: --We use a un-shipped profile option FII_TEST_SYSDATE ("FII: Test Sysdate")
457: --to reset different sysdate so that we can test for snapshot tables.
458: if g_test_sysdate is NULL THEN
459: SELECT trunc(CURRENT_DATE_ID) INTO l_this_date
460: FROM BIS_SYSTEM_DATE;
461: ELSE
462: l_this_date := g_test_sysdate;
463: end if;
464: