APPS.FA_SLA_CURRENT_PERIOD_UPG_PKG dependencies on FA_DISTRIBUTION_HISTORY

Line 915: from fa_distribution_history dh

911: dh.transaction_units,
912: dh.assigned_to,
913: dh.code_combination_id,
914: dh.location_id
915: from fa_distribution_history dh
916: where dh.book_type_code = l_book_type_code
917: and dh.asset_id = l_asset_id
918: and dh.transaction_header_id_out = l_transaction_header_id
919: union all

Line 926: from fa_distribution_history dh

922: dh.transaction_units,
923: dh.assigned_to,
924: dh.code_combination_id,
925: dh.location_id
926: from fa_distribution_history dh
927: where dh.book_type_code = l_book_type_code
928: and dh.asset_id = l_asset_id
929: and dh.transaction_header_id_in = l_transaction_header_id;
930:

Line 1757: fa_distribution_history dh,

1753: from fa_transaction_headers th,
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