APPS.FA_SLA_CURRENT_PERIOD_UPG_PKG dependencies on FA_ADJUSTMENTS

Line 55: from fa_adjustments aj

51: and th.transaction_header_id = bk.transaction_header_id_in
52: and bk.cost <> 0
53: and th.asset_id = ad.asset_id
54: and not exists (select 'x'
55: from fa_adjustments aj
56: where aj.asset_id = th.asset_id
57: and aj.book_type_code = th.book_type_code
58: and aj.transaction_header_id = th.transaction_header_id
59: and aj.adjustment_type like '%COST');

Line 1756: fa_adjustments adj,

1752: adj.code_combination_id
1753: from fa_transaction_headers th,
1754: fa_book_controls bc,
1755: fa_deprn_periods dp,
1756: fa_adjustments adj,
1757: fa_asset_invoices ai,
1758: fa_invoice_transactions it,
1759: (select 'SOURCE' source_dest_code from dual union all
1760: select 'DEST' source_dest_code from dual) mult

Line 1796: fa_adjustments adj,

1792: adj.code_combination_id
1793: from fa_transaction_headers th,
1794: fa_book_controls bc,
1795: fa_deprn_periods dp,
1796: fa_adjustments adj,
1797: fa_distribution_history dh,
1798: (select 'SOURCE' source_dest_code from dual union all
1799: select 'DEST' source_dest_code from dual) mult
1800: where th.rowid between p_start_rowid and p_end_rowid

Line 1843: update fa_adjustments

1839:
1840: l_rows_processed := l_adj_rowid_tbl.count;
1841:
1842: forall i in 1..l_adj_rowid_tbl.count
1843: update fa_adjustments
1844: set source_line_id = l_source_line_id_tbl(i),
1845: source_dest_code = l_source_dest_code_tbl(i)
1846: where rowid = l_adj_rowid_tbl(i);
1847:

Line 1898: update fa_adjustments

1894:
1895: l_rows_processed := l_adj_rowid_tbl.count;
1896:
1897: forall i in 1..l_adj_rowid_tbl.count
1898: update fa_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