APPS.FA_TRACK_MEMBER_PVT dependencies on FA_RETIREMENTS

Line 4434: -- Query fa_retirements for entered eofy_reserve

4430: if nvl(h_asset_id,-99) = h_member_asset_id
4431: and h_period_counter = h_trans_period_counter
4432: and nvl(h_transaction_type_code,'NULL') in ('PARTIAL RETIREMENT','FULL RETIREMENT') then
4433:
4434: -- Query fa_retirements for entered eofy_reserve
4435: if p_group_rule_in.mrc_sob_type_code <> 'R' then
4436:
4437: select recognize_gain_loss,nvl(eofy_reserve,0),(-1)*nvl(reserve_retired,0)
4438: into h_recognize_gain_loss,h_adj_eofy_reserve,h_reserve_retired

Line 4439: from fa_retirements

4435: if p_group_rule_in.mrc_sob_type_code <> 'R' then
4436:
4437: select recognize_gain_loss,nvl(eofy_reserve,0),(-1)*nvl(reserve_retired,0)
4438: into h_recognize_gain_loss,h_adj_eofy_reserve,h_reserve_retired
4439: from fa_retirements
4440: where transaction_header_id_in = h_adj_member_trans_header_id;
4441: else
4442:
4443: select recognize_gain_loss,nvl(eofy_reserve,0),(-1)*nvl(reserve_retired,0)

Line 6164: from fa_retirements ret

6160:
6161: --* Cursor for EOFY_RESERVE adjustment
6162: cursor FA_RET_RSV is
6163: select sum(nvl(ret.reserve_retired,0) - nvl(ret.eofy_reserve,0))
6164: from fa_retirements ret
6165: where ret.book_type_code = h_book_type_code
6166: and ret.asset_id = h_member_asset_id
6167: and exists
6168: (select th1.transaction_header_id

Line 8560: --* Cursor to get eofy_reserve adjustment from fa_retirements

8556: and BK_OUT.group_asset_id(+) = BK_IN.group_Asset_id
8557: and BK_OUT.asset_id(+) = BK_IN.asset_id
8558: and BK_OUT.transaction_header_id_out(+) = BK_IN.transaction_header_id_in;
8559:
8560: --* Cursor to get eofy_reserve adjustment from fa_retirements
8561: cursor GET_RETIREMENTS(p_thid number) is
8562: select recognize_gain_loss,
8563: nvl(eofy_reserve,0),
8564: (-1)*nvl(reserve_retired,0)

Line 8565: from fa_retirements

8561: cursor GET_RETIREMENTS(p_thid number) is
8562: select recognize_gain_loss,
8563: nvl(eofy_reserve,0),
8564: (-1)*nvl(reserve_retired,0)
8565: from fa_retirements
8566: where transaction_header_id_in = p_thid;
8567:
8568: cursor GET_RETIREMENTS_MRC(p_thid number) is
8569: select recognize_gain_loss,

Line 8572: from fa_retirements_mrc_v

8568: cursor GET_RETIREMENTS_MRC(p_thid number) is
8569: select recognize_gain_loss,
8570: nvl(eofy_reserve,0),
8571: (-1)*nvl(reserve_retired,0)
8572: from fa_retirements_mrc_v
8573: where transaction_header_id_in = p_thid;
8574:
8575: --* Cursor to get reserve retired for reinstatement
8576: cursor GET_REINSTATEMENT(p_thid number) is

Line 8580: from fa_retirements

8576: cursor GET_REINSTATEMENT(p_thid number) is
8577: select recognize_gain_loss,
8578: nvl(eofy_reserve,0),
8579: nvl(reserve_retired,0)
8580: from fa_retirements
8581: where transaction_header_id_out = p_thid;
8582:
8583: cursor GET_REINSTATEMENT_MRC(p_thid number) is
8584: select recognize_gain_loss,

Line 8587: from fa_retirements_mrc_v

8583: cursor GET_REINSTATEMENT_MRC(p_thid number) is
8584: select recognize_gain_loss,
8585: nvl(eofy_reserve,0),
8586: nvl(reserve_retired,0)
8587: from fa_retirements_mrc_v
8588: where transaction_header_id_out = p_thid;
8589:
8590: --* Cursor to query reserve/ytd at addition
8591: cursor GET_RESERVE_AT_ADDITION(p_asset_id number, p_period_counter number) is

Line 10373: from fa_retirements ret

10369:
10370: --* Cursor for EOFY_RESERVE adjustment
10371: cursor FA_RET_RSV is
10372: select sum(nvl(ret.reserve_retired,0) - nvl(ret.eofy_reserve,0))
10373: from fa_retirements ret
10374: where ret.book_type_code = h_book_type_code
10375: and ret.asset_id = h_member_asset_id
10376: and exists
10377: (select th1.transaction_header_id

Line 10398: from fa_retirements_mrc_v ret

10394: and th1.transaction_header_id = ret.transaction_header_id_in);
10395:
10396: cursor FA_RET_RSV_MRC is
10397: select sum(nvl(ret.reserve_retired,0) - nvl(ret.eofy_reserve,0))
10398: from fa_retirements_mrc_v ret
10399: where ret.book_type_code = h_book_type_code
10400: and ret.asset_id = h_member_asset_id
10401: and exists
10402: (select th1.transaction_header_id