APPS.IGI_IAC_RETIREMENT dependencies on FA_DISTRIBUTION_HISTORY

Line 60: FROM fa_distribution_history

56: WHERE adjustment_id = p_current_adjustment ;
57:
58: CURSOR c_units_per_dist (p_c_asset_id NUMBER, p_c_book_type_code VARCHAR2, p_dist_id NUMBER) IS
59: SELECT units_assigned, transaction_units
60: FROM fa_distribution_history
61: WHERE asset_id = p_c_asset_id
62: AND book_type_code = p_c_book_type_code
63: AND distribution_id = p_dist_id ;
64:

Line 77: FROM fa_distribution_history NEW, fa_distribution_history old

73:
74: g_asset_balances_rec igi_iac_asset_balances%ROWTYPE ;
75: CURSOR c_new_distribution (p_c_retirement_id NUMBER, p_old_distribution NUMBER ) IS
76: SELECT new.distribution_id
77: FROM fa_distribution_history NEW, fa_distribution_history old
78: WHERE old.retirement_id = p_c_retirement_id
79: AND old.location_id = new.location_id
80: AND old.code_combination_id = new.code_combination_id
81: AND NVL(old.assigned_to,-99) = NVL(new.assigned_to,-99)

Line 111: FROM fa_distribution_history fad

107: p_retirement_id Number,
108: p_distribution_id Number )
109: IS
110: SELECT *
111: FROM fa_distribution_history fad
112: WHERE fad.asset_id = p_asset_id
113: AND fad.retirement_id = p_retirement_id
114: AND fad.distribution_id = p_distribution_id;
115:

Line 124: FROM fa_distribution_history fad

120: p_location_id Number,
121: P_assigned_to Number)
122: IS
123: SELECT *
124: FROM fa_distribution_history fad
125: WHERE fad.asset_id = p_asset_id
126: AND fad.code_combination_id = p_code_combination_id
127: AND fad.units_assigned = p_transaction_units
128: AND fad.location_id = p_location_id