APPS.CSE_ASSET_CREATION_PKG dependencies on FA_DISTRIBUTION_HISTORY

Line 1891: FROM fa_distribution_history

1887:
1888: CURSOR dist_cur IS
1889: SELECT distribution_id,
1890: units_assigned
1891: FROM fa_distribution_history
1892: WHERE asset_id = p_mass_add_rec.asset_id
1893: AND book_type_code = p_mass_add_rec.book_type_code
1894: AND location_id = p_mass_add_rec.location_id
1895: AND code_combination_id = nvl(p_mass_add_rec.expense_code_combination_id , code_combination_id)

Line 2977: FROM fa_distribution_history

2973: ,location_id
2974: ,code_combination_id
2975: ,assigned_to
2976: ,units_assigned
2977: FROM fa_distribution_history
2978: WHERE asset_id = p_asset_query_rec.asset_id
2979: AND book_type_code = NVL(p_asset_query_rec.book_type_code,book_type_code)
2980: AND location_id = NVL(p_mass_add_rec.location_id , location_id)
2981: AND code_combination_id = NVL(p_mass_add_rec.expense_code_combination_id , code_combination_id)

Line 2991: FROM fa_distribution_history

2987: ,book_type_code
2988: ,location_id
2989: ,code_combination_id
2990: ,assigned_to
2991: FROM fa_distribution_history
2992: WHERE asset_id = p_asset_query_rec.asset_id
2993: AND book_type_code = NVL(p_asset_query_rec.book_type_code,book_type_code)
2994: AND date_ineffective IS NULL ;
2995:

Line 3185: FROM fa_distribution_history

3181: ,location_id
3182: ,assigned_to
3183: ,code_combination_id
3184: ,units_assigned
3185: FROM fa_distribution_history
3186: WHERE asset_id = p_asset_query_rec.asset_id
3187: AND book_type_code = p_asset_query_rec.book_type_code
3188: AND location_id = NVL(p_asset_query_rec.location_id,location_id)
3189: AND code_combination_id = NVL(p_asset_query_rec.deprn_expense_ccid,code_combination_id)