APPS.EAM_ASSET_NUMBER_PVT dependencies on FA_DISTRIBUTION_HISTORY

Line 349: from fa_distribution_history fdh

345: and rownum = 1;
346:
347: select fdh.location_id
348: into l_asset_assignment_tbl(1).fa_location_id
349: from fa_distribution_history fdh
350: where asset_id = P_FA_ASSET_ID
351: and book_type_code = l_asset_assignment_tbl(1).fa_book_type_code
352: and date_ineffective is null
353: and rownum = 1;

Line 670: from fa_distribution_history fdh

666: and rownum = 1;
667:
668: select fdh.location_id
669: into l_asset_assignment_tbl(1).fa_location_id
670: from fa_distribution_history fdh
671: where asset_id = P_FA_ASSET_ID
672: and book_type_code = l_asset_assignment_tbl(1).fa_book_type_code
673: and date_ineffective is null
674: and rownum = 1;

Line 721: from fa_distribution_history fdh

717: and rownum = 1;
718:
719: select fdh.location_id
720: into l_asset_assignment_tbl(1).fa_location_id
721: from fa_distribution_history fdh
722: where asset_id = l_asset_assignment_tbl(1).fa_asset_id
723: and book_type_code = l_asset_assignment_tbl(1).fa_book_type_code
724: and date_ineffective is null
725: and rownum = 1;