eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FA_AMORT_PVT dependencies on DUAL

Line 11572: from dual

11568: )
11569: union all select
11570: p_trans_rec.transaction_date_entered transaction_date_entered,
11571: p_trans_rec.who_info.creation_date date_effective
11572: from dual
11573: where p_reclass_src_dest is null
11574: and p_trans_rec.transaction_date_entered >= c_transaction_date_entered
11575: and p_trans_rec.who_info.creation_date = c_date_effective
11576: and (p_asset_type_rec.asset_type <> G_ASSET_TYPE_GROUP or

Line 11755: from dual

11751: nvl(p_trans_rec.amortization_start_date,
11752: p_trans_rec.transaction_date_entered) transaction_date_entered,
11753: p_trans_rec.who_info.creation_date date_effective,
11754: p_trans_rec.transaction_type_code transaction_type_code
11755: from dual
11756: where not exists (select 'Y'
11757: from fa_transaction_headers mth,
11758: fa_books bk
11759: where mth.transaction_header_id = p_trans_rec.member_transaction_header_id

Line 14185: from dual;

14181: 'Y', l_asset_fin_rec_new.period_counter_fully_extended,
14182: l_asset_fin_rec_new.period_counter_fully_reserved)
14183: into l_old_pc_reserved,
14184: l_new_pc_reserved
14185: from dual;
14186: end;
14187:
14188: -- bug 5383699 nvl clause added
14189: if (l_old_pc_reserved is not null