DBA Data[Home] [Help]

APPS.FV_GTAS_INTERFACE dependencies on FV_GTAS1_PERIOD_BALANCES_V

Line 1719: FROM fv_gtas1_period_balances_v t2

1715: Gbl_Fiscal_Year,
1716: T2.D_C_Indicator,
1717: Sum(Nvl(Amount,0)),
1718: 'Y'
1719: FROM fv_gtas1_period_balances_v t2
1720: WHERE t2.set_of_books_id = gbl_set_of_books_id
1721: And Period_Year = Gbl_Fiscal_Year
1722: and period_num <= gbl_period_num_high
1723: AND t2.begin_end = 'E'

Line 1770: --Set the reported_group to Null so that fv_gtas1_period_balances_v

1766:
1767: log(l_module_name, 'Deleted '||SQL%ROWCOUNT||
1768: ' records from fv_gtas_diff_balances.');
1769:
1770: --Set the reported_group to Null so that fv_gtas1_period_balances_v
1771: --picks up only the rows processed in the current run
1772: log(l_module_name, 'Setting reported_group to NULL');
1773: UPDATE fv_gtas1_period_attributes
1774: SET reported_group = NULL