DBA Data[Home] [Help]

APPS.FA_ASSET_VAL_PVT dependencies on FA_DEPRN_DETAIL

Line 2928: from fa_deprn_detail dd,

2924:
2925: begin
2926: select count(*)
2927: into l_count2
2928: from fa_deprn_detail dd,
2929: fa_distribution_history dh
2930: where dd.asset_id = p_asset_id
2931: and dd.asset_id = dh.asset_id
2932: and dd.distribution_id = dh.distribution_id

Line 6261: from fa_deprn_detail fdd,

6257: ) RETURN BOOLEAN IS
6258:
6259: CURSOR c_check_dist IS
6260: select count(1)
6261: from fa_deprn_detail fdd,
6262: fa_distribution_history fdh
6263: where fdd.distribution_id = fdh.distribution_id
6264: and fdd.book_type_code = p_book_type_code
6265: and fdd.asset_id = p_asset_Id