APPS.FA_ASSET_VAL_PVT dependencies on FA_MASS_ADDITIONS

Line 463: -- Need to check fa_mass_additions also. Only do this validation

459: name => 'FA_ADD_ASSET_NUMBER_USED', p_log_level_rec => p_log_level_rec);
460: return FALSE;
461: end if;
462:
463: -- Need to check fa_mass_additions also. Only do this validation
464: -- if it is being called from Prepare Mass Additions. Otherwise,
465: -- it fails during Post Mass Additions.
466: if (p_calling_fn = 'MASS_ADDITIONS_7.Check_S_Asset_Number') then
467: select count(*)

Line 469: from fa_mass_additions

465: -- it fails during Post Mass Additions.
466: if (p_calling_fn = 'MASS_ADDITIONS_7.Check_S_Asset_Number') then
467: select count(*)
468: into l_count
469: from fa_mass_additions
470: where asset_number = p_asset_number
471: and queue_name = 'POST'; -- fix for bug 3433702
472:
473: --if (l_count > 1) then

Line 2727: from fa_mass_additions

2723: BEGIN
2724:
2725: select count(*)
2726: into l_count
2727: from fa_mass_additions
2728: where book_type_code = p_book
2729: and add_to_asset_id = p_asset_id
2730: and posting_status not in ('POSTED','MERGED','SPLIT','DELETE')
2731: and rownum < 2;