APPS.FA_RETIREMENT_PVT dependencies on FA_DISTRIBUTION_HISTORY

Line 751: select FA_DISTRIBUTION_HISTORY_S.NEXTVAL

747:
748: l_out_trx_id NUMBER(15); -- Transfer Out thid due to retirement
749:
750: CURSOR c_get_ret_dists IS
751: select FA_DISTRIBUTION_HISTORY_S.NEXTVAL
752: , -1 * transaction_units
753: , assigned_to
754: , code_combination_id
755: , location_id

Line 756: from fa_distribution_history

752: , -1 * transaction_units
753: , assigned_to
754: , code_combination_id
755: , location_id
756: from fa_distribution_history
757: where retirement_id = p_asset_retire_rec.retirement_id;
758:
759: CURSOR c_get_cur_dists (c_assigned_to number,
760: c_expense_ccid number,

Line 764: from fa_distribution_history

760: c_expense_ccid number,
761: c_location_ccid number) IS
762: select distribution_id
763: , units_assigned + nvl(transaction_units, 0)
764: from fa_distribution_history
765: where asset_id = p_asset_hdr_rec.asset_id
766: and book_type_code = p_asset_hdr_rec.book_type_code
767: and transaction_header_id_out is null
768: and (assigned_to = c_assigned_to

Line 843: from fa_distribution_history

839: , transaction_header_id_in
840: , transaction_header_id_out
841: , units_assigned
842: , transaction_units
843: from fa_distribution_history
844: where asset_id = p_asset_hdr_rec.asset_id
845: order by distribution_id;
846:
847:

Line 924: update FA_DISTRIBUTION_HISTORY

920: CLOSE c_get_cur_dists;
921:
922: if (l_distribution_id is not null) then
923:
924: update FA_DISTRIBUTION_HISTORY
925: set transaction_units = nvl(transaction_units, t_units_assigned(i)),
926: transaction_header_id_out = p_trans_rec.transaction_header_id,
927: date_ineffective = p_trans_rec.who_info.last_update_date,
928: last_update_date = p_trans_rec.who_info.last_update_date,

Line 941: insert into FA_DISTRIBUTION_HISTORY(

937: end loop;
938:
939: -- +++++ Create retired distributions +++++
940: FORALL i in 1..t_distribution_id.LAST
941: insert into FA_DISTRIBUTION_HISTORY(
942: DISTRIBUTION_ID,
943: BOOK_TYPE_CODE,
944: ASSET_ID,
945: UNITS_ASSIGNED,

Line 1464: from fa_distribution_history

1460: -- Cursor to get transaction header id of transfer out in
1461: -- case of partial unit retirement
1462: CURSOR c_get_thid IS
1463: select distinct nvl(transaction_header_id_out,0)
1464: from fa_distribution_history
1465: where asset_id = p_asset_hdr_rec.asset_id
1466: and book_type_code = p_asset_hdr_rec.book_type_code
1467: and retirement_id = p_asset_retire_rec.retirement_id; */
1468:

Line 2203: from fa_distribution_history

2199: -- Cursor to get transaction header id of transfer out in
2200: -- case of partial unit retirement
2201: CURSOR c_get_thid_for_dist IS
2202: /* select transaction_header_id_out
2203: from fa_distribution_history
2204: where asset_id = p_asset_hdr_rec.asset_id
2205: and book_type_code = p_asset_hdr_rec.book_type_code
2206: and retirement_id = p_asset_retire_rec.retirement_id;
2207: bug 4411892*/