APPS.FA_RX_GROUP dependencies on FA_RETIREMENTS

Line 281: -- Query fa_retirements

277: ----------------------------------------------------------
278: -- Query add/adj/retirement amount in the FY
279: ----------------------------------------------------------
280:
281: -- Query fa_retirements
282: -- (retiring member asset is allowed only in current period)
283: SELECT NVL(SUM(ret.proceeds_of_sale), 0),
284: NVL(SUM(ret.cost_of_removal), 0),
285: NVL(SUM(ret.nbv_retired), 0),

Line 295: FROM fa_retirements ret,

291: l_group_rec.net_proceeds,
292: l_group_rec.cost_retired,
293: l_group_rec.reserve_retired,
294: l_group_rec.recapture_amount
295: FROM fa_retirements ret,
296: fa_book_controls bc,
297: fa_fiscal_year fy,
298: fa_transaction_headers thg,
299: fa_transaction_headers thm

Line 1040: FROM fa_retirements ret,

1036: NVL(SUM(ret.proceeds_of_sale), 0) proceeds_of_sale,
1037: NVL(SUM(ret.cost_of_removal), 0) cost_of_removal,
1038: NVL(SUM(ret.cost_retired), 0) cost_retired,
1039: NVL(SUM(ret.reserve_retired), 0) reserve_retired
1040: FROM fa_retirements ret,
1041: fa_book_controls bc,
1042: fa_fiscal_year fy,
1043: fa_transaction_headers thm,
1044: fa_books bkm