APPS.FA_SLA_CURRENT_PERIOD_UPG_PKG dependencies on DUAL

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

1715: fa_deprn_periods dp,
1716: fa_adjustments adj,
1717: fa_asset_invoices ai,
1718: fa_invoice_transactions it,
1719: (select 'SOURCE' source_dest_code from dual union all
1720: select 'DEST' source_dest_code from dual) mult
1721: where th.rowid between p_start_rowid and p_end_rowid
1722: and bc.book_type_code = th.book_type_code
1723: and nvl(bc.date_ineffective, sysdate) <= sysdate

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

1716: fa_adjustments adj,
1717: fa_asset_invoices ai,
1718: fa_invoice_transactions it,
1719: (select 'SOURCE' source_dest_code from dual union all
1720: select 'DEST' source_dest_code from dual) mult
1721: where th.rowid between p_start_rowid and p_end_rowid
1722: and bc.book_type_code = th.book_type_code
1723: and nvl(bc.date_ineffective, sysdate) <= sysdate
1724: and bc.book_type_code = dp.book_type_code

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

1754: fa_book_controls bc,
1755: fa_deprn_periods dp,
1756: fa_adjustments adj,
1757: fa_distribution_history dh,
1758: (select 'SOURCE' source_dest_code from dual union all
1759: select 'DEST' source_dest_code from dual) mult
1760: where th.rowid between p_start_rowid and p_end_rowid
1761: and bc.book_type_code = th.book_type_code
1762: and nvl(bc.date_ineffective, sysdate) <= sysdate

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

1755: fa_deprn_periods dp,
1756: fa_adjustments adj,
1757: fa_distribution_history dh,
1758: (select 'SOURCE' source_dest_code from dual union all
1759: select 'DEST' source_dest_code from dual) mult
1760: where th.rowid between p_start_rowid and p_end_rowid
1761: and bc.book_type_code = th.book_type_code
1762: and nvl(bc.date_ineffective, sysdate) <= sysdate
1763: and bc.book_type_code = dp.book_type_code