DBA Data[Home] [Help]

APPS.FA_AMORT_PVT dependencies on DUAL

Line 12047: from dual

12043: )
12044: union all select
12045: p_trans_rec.transaction_date_entered transaction_date_entered,
12046: p_trans_rec.who_info.creation_date date_effective
12047: from dual
12048: where p_reclass_src_dest is null
12049: and p_trans_rec.transaction_date_entered >= c_transaction_date_entered
12050: and p_trans_rec.who_info.creation_date = c_date_effective
12051: and (p_asset_type_rec.asset_type <> G_ASSET_TYPE_GROUP or

Line 12324: from dual

12320: nvl(p_trans_rec.amortization_start_date,
12321: p_trans_rec.transaction_date_entered) transaction_date_entered,
12322: p_trans_rec.who_info.creation_date date_effective,
12323: p_trans_rec.transaction_type_code transaction_type_code
12324: from dual
12325: where not exists (select 'Y'
12326: from fa_transaction_headers mth,
12327: fa_books bk
12328: where mth.transaction_header_id = p_trans_rec.member_transaction_header_id

Line 15258: from dual;

15254: l_asset_fin_rec_new.period_counter_fully_reserved),
15255: l_asset_fin_rec_new.period_counter_fully_reserved)
15256: into l_old_pc_reserved,
15257: l_new_pc_reserved
15258: from dual;
15259:
15260: end;
15261:
15262: -- bug 5383699 nvl clause added