APPS.FA_TRACK_MEMBER_PVT dependencies on FA_RETIREMENTS

Line 4590: -- Query fa_retirements for entered eofy_reserve

4586: if nvl(h_asset_id,-99) = h_member_asset_id
4587: and h_period_counter = h_trans_period_counter
4588: and nvl(h_transaction_type_code,'NULL') in ('PARTIAL RETIREMENT','FULL RETIREMENT') then
4589:
4590: -- Query fa_retirements for entered eofy_reserve
4591: if p_group_rule_in.mrc_sob_type_code <> 'R' then
4592:
4593: select recognize_gain_loss,nvl(eofy_reserve,0),(-1)*nvl(reserve_retired,0)
4594: into h_recognize_gain_loss,h_adj_eofy_reserve,h_reserve_retired

Line 4595: from fa_retirements

4591: if p_group_rule_in.mrc_sob_type_code <> 'R' then
4592:
4593: select recognize_gain_loss,nvl(eofy_reserve,0),(-1)*nvl(reserve_retired,0)
4594: into h_recognize_gain_loss,h_adj_eofy_reserve,h_reserve_retired
4595: from fa_retirements
4596: where transaction_header_id_in = h_adj_member_trans_header_id;
4597: else
4598:
4599: select recognize_gain_loss,nvl(eofy_reserve,0),(-1)*nvl(reserve_retired,0)

Line 6326: from fa_retirements ret

6322:
6323: --* Cursor for EOFY_RESERVE adjustment
6324: cursor FA_RET_RSV is
6325: select sum(nvl(ret.reserve_retired,0) - nvl(ret.eofy_reserve,0))
6326: from fa_retirements ret
6327: where ret.book_type_code = h_book_type_code
6328: and ret.asset_id = h_member_asset_id
6329: and exists
6330: (select th1.transaction_header_id

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

8826: and BK_OUT.asset_id(+) = BK_IN.asset_id
8827: and BK_OUT.transaction_header_id_out(+) = BK_IN.transaction_header_id_in
8828: and BK_OUT.set_of_books_id(+) = h_set_of_books_id ; --Bug 8941132
8829:
8830: --* Cursor to get eofy_reserve adjustment from fa_retirements
8831: cursor GET_RETIREMENTS(p_thid number) is
8832: select recognize_gain_loss,
8833: nvl(eofy_reserve,0),
8834: (-1)*nvl(reserve_retired,0)

Line 8835: from fa_retirements

8831: cursor GET_RETIREMENTS(p_thid number) is
8832: select recognize_gain_loss,
8833: nvl(eofy_reserve,0),
8834: (-1)*nvl(reserve_retired,0)
8835: from fa_retirements
8836: where transaction_header_id_in = p_thid;
8837:
8838: cursor GET_RETIREMENTS_MRC(p_thid number) is
8839: select recognize_gain_loss,

Line 8851: from fa_retirements

8847: cursor GET_REINSTATEMENT(p_thid number) is
8848: select recognize_gain_loss,
8849: nvl(eofy_reserve,0),
8850: nvl(reserve_retired,0)
8851: from fa_retirements
8852: where transaction_header_id_out = p_thid;
8853:
8854: cursor GET_REINSTATEMENT_MRC(p_thid number) is
8855: select recognize_gain_loss,

Line 10702: from fa_retirements ret

10698:
10699: --* Cursor for EOFY_RESERVE adjustment
10700: cursor FA_RET_RSV is
10701: select sum(nvl(ret.reserve_retired,0) - nvl(ret.eofy_reserve,0))
10702: from fa_retirements ret
10703: where ret.book_type_code = h_book_type_code
10704: and ret.asset_id = h_member_asset_id
10705: and exists
10706: (select th1.transaction_header_id