APPS.FA_CALC_DEPRN_BASIS2_PKG dependencies on FA_RETIREMENTS

Line 1778: from FA_RETIREMENTS RET,

1774:
1775: -- Get Eofy reserve retired on current fiscal year
1776: Cursor C_EOFY_RESERVE_RETIRED is
1777: select nvl(sum(RET.EOFY_RESERVE),0)
1778: from FA_RETIREMENTS RET,
1779: FA_TRANSACTION_HEADERS TH,
1780: FA_DEPRN_PERIODS DP,
1781: FA_FISCAL_YEAR FY,
1782: FA_BOOK_CONTROLS BC

Line 1823: from FA_RETIREMENTS RET,

1819: ;
1820:
1821: Cursor GP_EOFY_RESERVE_RETIRED is
1822: select nvl(sum(RET.EOFY_RESERVE),0)
1823: from FA_RETIREMENTS RET,
1824: FA_TRANSACTION_HEADERS TH,
1825: FA_DEPRN_PERIODS DP,
1826: FA_FISCAL_YEAR FY,
1827: FA_BOOK_CONTROLS BC

Line 1882: from FA_RETIREMENTS RET

1878:
1879: -- current transaction's member eofy reserve retired
1880: Cursor CUR_EOFY_RESERVE_RETIRED is
1881: select nvl(sum(RET.EOFY_RESERVE),0)
1882: from FA_RETIREMENTS RET
1883: where RET.TRANSACTION_HEADER_ID_IN = px_rule_in.adj_mem_transaction_header_id
1884: ;
1885:
1886: Cursor CUR_EOFY_RESERVE_RETIRED_M is