DBA Data[Home] [Help]

APPS.FA_SLA_CURRENT_PERIOD_UPG_PKG dependencies on FA_MC_ADJUSTMENTS

Line 364: from fa_mc_adjustments aj

360: and mcbc.enabled_flag = 'Y'
361: and bk.cost <> 0
362: and th.asset_id = ad.asset_id
363: and not exists (select 'x'
364: from fa_mc_adjustments aj
365: where aj.asset_id = th.asset_id
366: and aj.book_type_code = th.book_type_code
367: and aj.set_of_books_id = mcbc.set_of_books_id
368: and aj.book_type_code = mcbc.book_type_code

Line 1809: update fa_mc_adjustments

1805: source_dest_code = l_source_dest_code_tbl(i)
1806: where rowid = l_adj_rowid_tbl(i);
1807:
1808: forall i in 1..l_adj_rowid_tbl.count
1809: update fa_mc_adjustments
1810: set source_line_id = l_source_line_id_tbl(i),
1811: source_dest_code = l_source_dest_code_tbl(i)
1812: where asset_id = l_asset_id_tbl(i)
1813: and book_type_code = l_book_type_code_tbl(i)

Line 1863: update fa_mc_adjustments

1859: set source_dest_code = l_source_dest_code_tbl(i)
1860: where rowid = l_adj_rowid_tbl(i);
1861:
1862: forall i in 1..l_adj_rowid_tbl.count
1863: update fa_mc_adjustments
1864: set source_dest_code = l_source_dest_code_tbl(i)
1865: where asset_id = l_asset_id_tbl(i)
1866: and book_type_code = l_book_type_code_tbl(i)
1867: and distribution_id = l_distribution_id_tbl(i)