APPS.CSE_ASSET_CREATION_PKG dependencies on FA_DISTRIBUTION_HISTORY

Line 1782: FROM fa_distribution_history

1778:
1779: CURSOR dist_cur IS
1780: SELECT distribution_id,
1781: units_assigned
1782: FROM fa_distribution_history
1783: WHERE asset_id = p_mass_add_rec.asset_id
1784: AND book_type_code = p_mass_add_rec.book_type_code
1785: AND location_id = p_mass_add_rec.location_id
1786: AND code_combination_id = nvl(p_mass_add_rec.expense_code_combination_id , code_combination_id)

Line 2641: FROM fa_distribution_history

2637: ,location_id
2638: ,code_combination_id
2639: ,assigned_to
2640: ,units_assigned
2641: FROM fa_distribution_history
2642: WHERE asset_id = p_asset_query_rec.asset_id
2643: AND book_type_code = NVL(p_asset_query_rec.book_type_code,book_type_code)
2644: AND location_id = NVL(p_mass_add_rec.location_id , location_id)
2645: AND code_combination_id = NVL(p_mass_add_rec.expense_code_combination_id , code_combination_id)

Line 2655: FROM fa_distribution_history

2651: ,book_type_code
2652: ,location_id
2653: ,code_combination_id
2654: ,assigned_to
2655: FROM fa_distribution_history
2656: WHERE asset_id = p_asset_query_rec.asset_id
2657: AND book_type_code = NVL(p_asset_query_rec.book_type_code,book_type_code)
2658: AND date_ineffective IS NULL ;
2659:

Line 2849: FROM fa_distribution_history

2845: ,location_id
2846: ,assigned_to
2847: ,code_combination_id
2848: ,units_assigned
2849: FROM fa_distribution_history
2850: WHERE asset_id = p_asset_query_rec.asset_id
2851: AND book_type_code = p_asset_query_rec.book_type_code
2852: AND location_id = NVL(p_asset_query_rec.location_id,location_id)
2853: AND code_combination_id = NVL(p_asset_query_rec.deprn_expense_ccid,code_combination_id)