APPS.JG_RX_FAREG dependencies on FA_DEPRN_SUMMARY

Line 1840: FROM fa_deprn_summary

1836: -- Get initial value
1837:
1838: SELECT (NVL(deprn_reserve,0) - NVL(bonus_deprn_reserve,0))
1839: INTO JG_RX_FAREG.var.deprn_reserve_initial
1840: FROM fa_deprn_summary
1841: WHERE book_type_code = PARM.p_book_type_code
1842: AND asset_id = JG_RX_FAREG.var.asset_id
1843: AND period_counter = (select max(period_counter)
1844: from fa_deprn_summary

Line 1844: from fa_deprn_summary

1840: FROM fa_deprn_summary
1841: WHERE book_type_code = PARM.p_book_type_code
1842: AND asset_id = JG_RX_FAREG.var.asset_id
1843: AND period_counter = (select max(period_counter)
1844: from fa_deprn_summary
1845: where period_counter <= (PARM.p_begin_period_counter-1)
1846: and asset_id= JG_RX_FAREG.var.asset_id
1847: and book_type_code = PARM.p_book_type_code );
1848:

Line 1865: FROM fa_deprn_summary

1861: SELECT (NVL(deprn_reserve,0) - NVL(bonus_deprn_reserve,0)),
1862: ytd_deprn
1863: INTO JG_RX_FAREG.var.deprn_reserve_final
1864: , JG_RX_FAREG.var.ytd_deprn
1865: FROM fa_deprn_summary
1866: WHERE book_type_code = PARM.p_book_type_code
1867: AND asset_id = JG_RX_FAREG.var.asset_id
1868: AND period_counter =
1869: (select max(period_counter)

Line 1870: from fa_deprn_summary

1866: WHERE book_type_code = PARM.p_book_type_code
1867: AND asset_id = JG_RX_FAREG.var.asset_id
1868: AND period_counter =
1869: (select max(period_counter)
1870: from fa_deprn_summary
1871: where period_counter <= PARM.p_end_period_counter
1872: and asset_id= JG_RX_FAREG.var.asset_id
1873: and book_type_code = PARM.p_book_type_code );
1874:

Line 1932: FROM fa_deprn_summary

1928: FA_RX_UTIL_PKG.debug('Get ordinary depreciation ');
1929:
1930: SELECT SUM((NVL(deprn_amount,0) - NVL(bonus_deprn_amount,0)))
1931: INTO X_ord_deprn
1932: FROM fa_deprn_summary
1933: WHERE book_type_code = PARM.p_book_type_code
1934: AND asset_id = JG_RX_FAREG.var.asset_id
1935: AND period_counter BETWEEN PARM.p_begin_period_counter
1936: AND PARM.p_end_period_counter;

Line 2127: FROM fa_deprn_summary

2123: -- Get initial value
2124:
2125: SELECT NVL(bonus_deprn_reserve,0)
2126: INTO JG_RX_FAREG.var.bonus_reserve_initial
2127: FROM fa_deprn_summary
2128: WHERE book_type_code = PARM.p_book_type_code
2129: AND asset_id = JG_RX_FAREG.var.asset_id
2130: AND period_counter =
2131: (SELECT max(period_counter)

Line 2132: FROM fa_deprn_summary

2128: WHERE book_type_code = PARM.p_book_type_code
2129: AND asset_id = JG_RX_FAREG.var.asset_id
2130: AND period_counter =
2131: (SELECT max(period_counter)
2132: FROM fa_deprn_summary
2133: WHERE period_counter <= (PARM.p_begin_period_counter-1)
2134: AND asset_id= JG_RX_FAREG.var.asset_id
2135: AND book_type_code = PARM.p_book_type_code );
2136:

Line 2151: FROM fa_deprn_summary

2147: FA_RX_UTIL_PKG.debug('Get bonus reserve final value');
2148: -- Get final value
2149: SELECT NVL(bonus_deprn_reserve,0)
2150: INTO JG_RX_FAREG.var.bonus_reserve_final
2151: FROM fa_deprn_summary
2152: WHERE book_type_code = PARM.p_book_type_code
2153: AND asset_id = JG_RX_FAREG.var.asset_id
2154: AND period_counter =
2155: (SELECT max(period_counter)

Line 2156: FROM fa_deprn_summary

2152: WHERE book_type_code = PARM.p_book_type_code
2153: AND asset_id = JG_RX_FAREG.var.asset_id
2154: AND period_counter =
2155: (SELECT max(period_counter)
2156: FROM fa_deprn_summary
2157: WHERE period_counter <= PARM.p_end_period_counter
2158: AND asset_id= JG_RX_FAREG.var.asset_id
2159: AND book_type_code = PARM.p_book_type_code );
2160:

Line 2215: FROM fa_deprn_summary

2211: FA_RX_UTIL_PKG.debug('Get bonus depreciation ');
2212:
2213: SELECT sum(bonus_deprn_amount)
2214: INTO X_bonus_deprn
2215: FROM fa_deprn_summary
2216: WHERE book_type_code = PARM.p_book_type_code
2217: AND asset_id = JG_RX_FAREG.var.asset_id
2218: AND period_counter BETWEEN PARM.p_begin_period_counter
2219: AND PARM.p_end_period_counter;