APPS.JG_RX_FAREG dependencies on FA_DEPRN_SUMMARY

Line 1856: FROM fa_deprn_summary

1852: -- Get initial value
1853:
1854: SELECT (NVL(deprn_reserve,0) - NVL(bonus_deprn_reserve,0))
1855: INTO JG_RX_FAREG.var.deprn_reserve_initial
1856: FROM fa_deprn_summary
1857: WHERE book_type_code = PARM.p_book_type_code
1858: AND asset_id = JG_RX_FAREG.var.asset_id
1859: AND period_counter = (select max(period_counter)
1860: from fa_deprn_summary

Line 1860: from fa_deprn_summary

1856: FROM fa_deprn_summary
1857: WHERE book_type_code = PARM.p_book_type_code
1858: AND asset_id = JG_RX_FAREG.var.asset_id
1859: AND period_counter = (select max(period_counter)
1860: from fa_deprn_summary
1861: where period_counter <= (PARM.p_begin_period_counter-1)
1862: and asset_id= JG_RX_FAREG.var.asset_id
1863: and book_type_code = PARM.p_book_type_code );
1864:

Line 1881: FROM fa_deprn_summary

1877: SELECT (NVL(deprn_reserve,0) - NVL(bonus_deprn_reserve,0)),
1878: ytd_deprn
1879: INTO JG_RX_FAREG.var.deprn_reserve_final
1880: , JG_RX_FAREG.var.ytd_deprn
1881: FROM fa_deprn_summary
1882: WHERE book_type_code = PARM.p_book_type_code
1883: AND asset_id = JG_RX_FAREG.var.asset_id
1884: AND period_counter =
1885: (select max(period_counter)

Line 1886: from fa_deprn_summary

1882: WHERE book_type_code = PARM.p_book_type_code
1883: AND asset_id = JG_RX_FAREG.var.asset_id
1884: AND period_counter =
1885: (select max(period_counter)
1886: from fa_deprn_summary
1887: where period_counter <= PARM.p_end_period_counter
1888: and asset_id= JG_RX_FAREG.var.asset_id
1889: and book_type_code = PARM.p_book_type_code );
1890:

Line 1948: FROM fa_deprn_summary

1944: FA_RX_UTIL_PKG.debug('Get ordinary depreciation ');
1945:
1946: SELECT SUM((NVL(deprn_amount,0) - NVL(bonus_deprn_amount,0)))
1947: INTO X_ord_deprn
1948: FROM fa_deprn_summary
1949: WHERE book_type_code = PARM.p_book_type_code
1950: AND asset_id = JG_RX_FAREG.var.asset_id
1951: AND period_counter BETWEEN PARM.p_begin_period_counter
1952: AND PARM.p_end_period_counter;

Line 2143: FROM fa_deprn_summary

2139: -- Get initial value
2140:
2141: SELECT NVL(bonus_deprn_reserve,0)
2142: INTO JG_RX_FAREG.var.bonus_reserve_initial
2143: FROM fa_deprn_summary
2144: WHERE book_type_code = PARM.p_book_type_code
2145: AND asset_id = JG_RX_FAREG.var.asset_id
2146: AND period_counter =
2147: (SELECT max(period_counter)

Line 2148: FROM fa_deprn_summary

2144: WHERE book_type_code = PARM.p_book_type_code
2145: AND asset_id = JG_RX_FAREG.var.asset_id
2146: AND period_counter =
2147: (SELECT max(period_counter)
2148: FROM fa_deprn_summary
2149: WHERE period_counter <= (PARM.p_begin_period_counter-1)
2150: AND asset_id= JG_RX_FAREG.var.asset_id
2151: AND book_type_code = PARM.p_book_type_code );
2152:

Line 2167: FROM fa_deprn_summary

2163: FA_RX_UTIL_PKG.debug('Get bonus reserve final value');
2164: -- Get final value
2165: SELECT NVL(bonus_deprn_reserve,0)
2166: INTO JG_RX_FAREG.var.bonus_reserve_final
2167: FROM fa_deprn_summary
2168: WHERE book_type_code = PARM.p_book_type_code
2169: AND asset_id = JG_RX_FAREG.var.asset_id
2170: AND period_counter =
2171: (SELECT max(period_counter)

Line 2172: FROM fa_deprn_summary

2168: WHERE book_type_code = PARM.p_book_type_code
2169: AND asset_id = JG_RX_FAREG.var.asset_id
2170: AND period_counter =
2171: (SELECT max(period_counter)
2172: FROM fa_deprn_summary
2173: WHERE period_counter <= PARM.p_end_period_counter
2174: AND asset_id= JG_RX_FAREG.var.asset_id
2175: AND book_type_code = PARM.p_book_type_code );
2176:

Line 2231: FROM fa_deprn_summary

2227: FA_RX_UTIL_PKG.debug('Get bonus depreciation ');
2228:
2229: SELECT sum(bonus_deprn_amount)
2230: INTO X_bonus_deprn
2231: FROM fa_deprn_summary
2232: WHERE book_type_code = PARM.p_book_type_code
2233: AND asset_id = JG_RX_FAREG.var.asset_id
2234: AND period_counter BETWEEN PARM.p_begin_period_counter
2235: AND PARM.p_end_period_counter;