APPS.JGRX_FAREG dependencies on FA_DEPRN_SUMMARY

Line 1609: FROM fa_deprn_summary

1605: -- Get initial value
1606:
1607: SELECT (NVL(deprn_reserve,0) - NVL(bonus_deprn_reserve,0))
1608: INTO JGRX_FAREG.var.deprn_reserve_initial
1609: FROM fa_deprn_summary
1610: WHERE book_type_code = PARM.p_book_type_code
1611: AND asset_id = JGRX_FAREG.var.asset_id
1612: AND period_counter = (select max(period_counter)
1613: from fa_deprn_summary

Line 1613: from fa_deprn_summary

1609: FROM fa_deprn_summary
1610: WHERE book_type_code = PARM.p_book_type_code
1611: AND asset_id = JGRX_FAREG.var.asset_id
1612: AND period_counter = (select max(period_counter)
1613: from fa_deprn_summary
1614: where period_counter <= (PARM.p_begin_period_counter-1)
1615: and asset_id= JGRX_FAREG.var.asset_id
1616: and book_type_code = PARM.p_book_type_code );
1617:

Line 1632: FROM fa_deprn_summary

1628: FA_RX_UTIL_PKG.debug('Get deprn reserve final value');
1629: -- Get final value
1630: SELECT (NVL(deprn_reserve,0) - NVL(bonus_deprn_reserve,0))
1631: INTO JGRX_FAREG.var.deprn_reserve_final
1632: FROM fa_deprn_summary
1633: WHERE book_type_code = PARM.p_book_type_code
1634: AND asset_id = JGRX_FAREG.var.asset_id
1635: AND period_counter =
1636: (select max(period_counter)

Line 1637: from fa_deprn_summary

1633: WHERE book_type_code = PARM.p_book_type_code
1634: AND asset_id = JGRX_FAREG.var.asset_id
1635: AND period_counter =
1636: (select max(period_counter)
1637: from fa_deprn_summary
1638: where period_counter <= PARM.p_end_period_counter
1639: and asset_id= JGRX_FAREG.var.asset_id
1640: and book_type_code = PARM.p_book_type_code );
1641:

Line 1694: FROM fa_deprn_summary

1690: FA_RX_UTIL_PKG.debug('Get ordinary depreciation ');
1691:
1692: SELECT SUM((NVL(deprn_amount,0) - NVL(bonus_deprn_amount,0)))
1693: INTO X_ord_deprn
1694: FROM fa_deprn_summary
1695: WHERE book_type_code = PARM.p_book_type_code
1696: AND asset_id = JGRX_FAREG.var.asset_id
1697: AND period_counter BETWEEN PARM.p_begin_period_counter
1698: AND PARM.p_end_period_counter;

Line 1853: FROM fa_deprn_summary

1849: -- Get initial value
1850:
1851: SELECT NVL(bonus_deprn_reserve,0)
1852: INTO JGRX_FAREG.var.bonus_reserve_initial
1853: FROM fa_deprn_summary
1854: WHERE book_type_code = PARM.p_book_type_code
1855: AND asset_id = JGRX_FAREG.var.asset_id
1856: AND period_counter =
1857: (SELECT max(period_counter)

Line 1858: FROM fa_deprn_summary

1854: WHERE book_type_code = PARM.p_book_type_code
1855: AND asset_id = JGRX_FAREG.var.asset_id
1856: AND period_counter =
1857: (SELECT max(period_counter)
1858: FROM fa_deprn_summary
1859: WHERE period_counter <= (PARM.p_begin_period_counter-1)
1860: AND asset_id= JGRX_FAREG.var.asset_id
1861: AND book_type_code = PARM.p_book_type_code );
1862:

Line 1877: FROM fa_deprn_summary

1873: FA_RX_UTIL_PKG.debug('Get bonus reserve final value');
1874: -- Get final value
1875: SELECT NVL(bonus_deprn_reserve,0)
1876: INTO JGRX_FAREG.var.bonus_reserve_final
1877: FROM fa_deprn_summary
1878: WHERE book_type_code = PARM.p_book_type_code
1879: AND asset_id = JGRX_FAREG.var.asset_id
1880: AND period_counter =
1881: (SELECT max(period_counter)

Line 1882: FROM fa_deprn_summary

1878: WHERE book_type_code = PARM.p_book_type_code
1879: AND asset_id = JGRX_FAREG.var.asset_id
1880: AND period_counter =
1881: (SELECT max(period_counter)
1882: FROM fa_deprn_summary
1883: WHERE period_counter <= PARM.p_end_period_counter
1884: AND asset_id= JGRX_FAREG.var.asset_id
1885: AND book_type_code = PARM.p_book_type_code );
1886:

Line 1941: FROM fa_deprn_summary

1937: FA_RX_UTIL_PKG.debug('Get bonus depreciation ');
1938:
1939: SELECT sum(bonus_deprn_amount)
1940: INTO X_bonus_deprn
1941: FROM fa_deprn_summary
1942: WHERE book_type_code = PARM.p_book_type_code
1943: AND asset_id = JGRX_FAREG.var.asset_id
1944: AND period_counter BETWEEN PARM.p_begin_period_counter
1945: AND PARM.p_end_period_counter;