APPS.FA_RX_GROUP dependencies on FA_RETIREMENTS

Line 351: -- Query fa_retirements

347: ----------------------------------------------------------
348: -- Query add/adj/retirement amount in the FY
349: ----------------------------------------------------------
350:
351: -- Query fa_retirements
352: -- (retiring member asset is allowed only in current period)
353: if(H_MRCSOBTYPE <> 'R') then -- MRC
354: SELECT NVL(SUM(ret.proceeds_of_sale), 0),
355: NVL(SUM(ret.cost_of_removal), 0),

Line 366: FROM fa_retirements ret,

362: l_group_rec.net_proceeds,
363: l_group_rec.cost_retired,
364: l_group_rec.reserve_retired,
365: l_group_rec.recapture_amount
366: FROM fa_retirements ret,
367: fa_book_controls bc,
368: fa_fiscal_year fy,
369: fa_transaction_headers thg,
370: fa_transaction_headers thm

Line 1375: FROM fa_retirements ret,

1371: NVL(SUM(ret.proceeds_of_sale), 0) proceeds_of_sale,
1372: NVL(SUM(ret.cost_of_removal), 0) cost_of_removal,
1373: NVL(SUM(ret.cost_retired), 0) cost_retired,
1374: NVL(SUM(ret.reserve_retired), 0) reserve_retired
1375: FROM fa_retirements ret,
1376: fa_book_controls bc,
1377: fa_fiscal_year fy,
1378: fa_transaction_headers thm,
1379: fa_books bkm