DBA Data[Home] [Help]

APPS.FA_SLA_CURRENT_PERIOD_UPG_PKG dependencies on FA_MC_ADJUSTMENTS

Line 377: from fa_mc_adjustments aj

373: and mcbc.enabled_flag = 'Y'
374: and bk.cost <> 0
375: and th.asset_id = ad.asset_id
376: and not exists (select 'x'
377: from fa_mc_adjustments aj
378: where aj.asset_id = th.asset_id
379: and aj.book_type_code = th.book_type_code
380: and aj.set_of_books_id = mcbc.set_of_books_id
381: and aj.book_type_code = mcbc.book_type_code

Line 1849: update fa_mc_adjustments

1845: source_dest_code = l_source_dest_code_tbl(i)
1846: where rowid = l_adj_rowid_tbl(i);
1847:
1848: forall i in 1..l_adj_rowid_tbl.count
1849: update fa_mc_adjustments
1850: set source_line_id = l_source_line_id_tbl(i),
1851: source_dest_code = l_source_dest_code_tbl(i)
1852: where asset_id = l_asset_id_tbl(i)
1853: and book_type_code = l_book_type_code_tbl(i)

Line 1903: update fa_mc_adjustments

1899: set source_dest_code = l_source_dest_code_tbl(i)
1900: where rowid = l_adj_rowid_tbl(i);
1901:
1902: forall i in 1..l_adj_rowid_tbl.count
1903: update fa_mc_adjustments
1904: set source_dest_code = l_source_dest_code_tbl(i)
1905: where asset_id = l_asset_id_tbl(i)
1906: and book_type_code = l_book_type_code_tbl(i)
1907: and distribution_id = l_distribution_id_tbl(i)