APPS.FA_RETIREMENT_PVT dependencies on FA_DISTRIBUTION_HISTORY

Line 813: select FA_DISTRIBUTION_HISTORY_S.NEXTVAL

809:
810: l_out_trx_id NUMBER(15); -- Transfer Out thid due to retirement
811:
812: CURSOR c_get_ret_dists IS
813: select FA_DISTRIBUTION_HISTORY_S.NEXTVAL
814: , -1 * transaction_units
815: , assigned_to
816: , code_combination_id
817: , location_id

Line 819: from fa_distribution_history

815: , assigned_to
816: , code_combination_id
817: , location_id
818: , units_assigned
819: from fa_distribution_history
820: where retirement_id = p_asset_retire_rec.retirement_id;
821:
822: CURSOR c_get_cur_dists (c_assigned_to number,
823: c_expense_ccid number,

Line 827: from fa_distribution_history

823: c_expense_ccid number,
824: c_location_ccid number) IS
825: select distribution_id
826: , units_assigned + nvl(transaction_units, 0)
827: from fa_distribution_history
828: where asset_id = p_asset_hdr_rec.asset_id
829: and book_type_code = p_asset_hdr_rec.book_type_code
830: and transaction_header_id_out is null
831: and (assigned_to = c_assigned_to

Line 918: from fa_distribution_history

914: , transaction_header_id_in
915: , transaction_header_id_out
916: , units_assigned
917: , transaction_units
918: from fa_distribution_history
919: where asset_id = p_asset_hdr_rec.asset_id
920: order by distribution_id;
921:
922:

Line 1000: update FA_DISTRIBUTION_HISTORY

996: CLOSE c_get_cur_dists;
997:
998: if (l_distribution_id is not null) then
999:
1000: update FA_DISTRIBUTION_HISTORY
1001: set transaction_units = nvl(transaction_units, t_units_assigned(i)),
1002: transaction_header_id_out = p_trans_rec.transaction_header_id,
1003: date_ineffective = p_trans_rec.who_info.last_update_date,
1004: last_update_date = p_trans_rec.who_info.last_update_date,

Line 1017: insert into FA_DISTRIBUTION_HISTORY(

1013: end loop;
1014:
1015: -- +++++ Create retired distributions +++++
1016: FORALL i in 1..t_distribution_id.LAST
1017: insert into FA_DISTRIBUTION_HISTORY(
1018: DISTRIBUTION_ID,
1019: BOOK_TYPE_CODE,
1020: ASSET_ID,
1021: UNITS_ASSIGNED,

Line 1535: from fa_distribution_history

1531: -- Cursor to get transaction header id of transfer out in
1532: -- case of partial unit retirement
1533: CURSOR c_get_thid IS
1534: select distinct nvl(transaction_header_id_out,0)
1535: from fa_distribution_history
1536: where asset_id = p_asset_hdr_rec.asset_id
1537: and book_type_code = p_asset_hdr_rec.book_type_code
1538: and retirement_id = p_asset_retire_rec.retirement_id; */
1539:

Line 2337: from fa_distribution_history

2333: -- Cursor to get transaction header id of transfer out in
2334: -- case of partial unit retirement
2335: CURSOR c_get_thid_for_dist IS
2336: /* select transaction_header_id_out
2337: from fa_distribution_history
2338: where asset_id = p_asset_hdr_rec.asset_id
2339: and book_type_code = p_asset_hdr_rec.book_type_code
2340: and retirement_id = p_asset_retire_rec.retirement_id;
2341: bug 4411892*/

Line 6752: from FA_DISTRIBUTION_HISTORY

6748: l_tot_deprn_reserve NUMBER;
6749: l_tot_bonus_reserve NUMBER;
6750: cursor c_inactive_dist is
6751: select distribution_id
6752: from FA_DISTRIBUTION_HISTORY
6753: where book_type_code = p_asset_hdr_rec.book_type_code
6754: and asset_id = p_asset_hdr_rec.asset_id
6755: and transaction_header_id_out = p_trans_rec.transaction_header_id;
6756: BEGIN