APPS.FA_SLA_CURRENT_PERIOD_UPG_PKG dependencies on DUAL

Line 1759: (select 'SOURCE' source_dest_code from dual union all

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
1761: where th.rowid between p_start_rowid and p_end_rowid
1762: and bc.book_type_code = th.book_type_code
1763: and nvl(bc.date_ineffective, sysdate + 1) > sysdate

Line 1760: select 'DEST' source_dest_code from dual) mult

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
1761: where th.rowid between p_start_rowid and p_end_rowid
1762: and bc.book_type_code = th.book_type_code
1763: and nvl(bc.date_ineffective, sysdate + 1) > sysdate
1764: and bc.book_type_code = dp.book_type_code

Line 1798: (select 'SOURCE' source_dest_code from dual union all

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
1801: and bc.book_type_code = th.book_type_code
1802: and nvl(bc.date_ineffective, sysdate + 1) > sysdate

Line 1799: select 'DEST' source_dest_code from dual) mult

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
1801: and bc.book_type_code = th.book_type_code
1802: and nvl(bc.date_ineffective, sysdate + 1) > sysdate
1803: and bc.book_type_code = dp.book_type_code