APPS.FA_SLA_CURRENT_PERIOD_UPG_PKG dependencies on FA_DISTRIBUTION_HISTORY

Line 932: from fa_distribution_history dh

928: dh.transaction_units,
929: dh.assigned_to,
930: dh.code_combination_id,
931: dh.location_id
932: from fa_distribution_history dh
933: where dh.book_type_code = l_book_type_code
934: and dh.asset_id = l_asset_id
935: and dh.transaction_header_id_out = l_transaction_header_id
936: union all

Line 943: from fa_distribution_history dh

939: dh.transaction_units,
940: dh.assigned_to,
941: dh.code_combination_id,
942: dh.location_id
943: from fa_distribution_history dh
944: where dh.book_type_code = l_book_type_code
945: and dh.asset_id = l_asset_id
946: and dh.transaction_header_id_in = l_transaction_header_id;
947:

Line 1797: fa_distribution_history dh,

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
1801: and bc.book_type_code = th.book_type_code