APPS.FA_TRANSFER_XIT_PKG dependencies on FA_DISTRIBUTION_HISTORY

Line 837: FA_DISTRIBUTION_HISTORY DH,

833: DH.DISTRIBUTION_ID,
834: DH.CODE_COMBINATION_ID,
835: DH.UNITS_ASSIGNED
836: FROM
837: FA_DISTRIBUTION_HISTORY DH,
838: FA_TRANSACTION_HEADERS TH
839: WHERE
840: TH.TRANSACTION_HEADER_ID = X_adj.selection_thid AND
841: (TH.TRANSACTION_HEADER_ID = DH.TRANSACTION_HEADER_ID_IN OR

Line 1952: ,fa_distribution_history fad

1948: -adj.annualized_adjustment)) annualized_adjustment,
1949: max(adj.track_member_flag) -- Bug7461343
1950: from fa_adjustments adj
1951: ,fa_additions_b ad
1952: ,fa_distribution_history fad
1953: where adj.asset_id = p_asset_id
1954: and adj.book_type_code = p_book_type_code
1955: and adj.source_type_code = 'DEPRECIATION'
1956: and adj.adjustment_type in ('EXPENSE', 'BONUS EXPENSE', 'IMPAIR EXPENSE')

Line 1978: ,fa_distribution_history fad

1974: -adj.annualized_adjustment)) annualized_adjustment,
1975: max(adj.track_member_flag) -- Bug7461343
1976: from fa_mc_adjustments adj
1977: ,fa_additions_b ad
1978: ,fa_distribution_history fad
1979: where adj.asset_id = p_asset_id
1980: and adj.book_type_code = p_book_type_code
1981: and adj.source_type_code = 'DEPRECIATION'
1982: and adj.adjustment_type in ('EXPENSE', 'BONUS EXPENSE', 'IMPAIR EXPENSE')

Line 1994: from fa_distribution_history dh

1990: group by adj.adjustment_type;
1991:
1992: CURSOR c_new_dists (p_thid number) IS
1993: select dh.distribution_id, dh.code_combination_id, dh.units_assigned
1994: from fa_distribution_history dh
1995: where dh.transaction_header_id_in = p_thid
1996: and dh.date_ineffective is null
1997: order by dh.distribution_id;
1998:

Line 2001: from fa_distribution_history dh

1997: order by dh.distribution_id;
1998:
1999: CURSOR c_sum_dists (p_thid number) IS
2000: select sum(dh.units_assigned)
2001: from fa_distribution_history dh
2002: where dh.transaction_header_id_in = p_thid;
2003:
2004: ERROR_FOUND EXCEPTION;
2005:

Line 2227: from fa_distribution_history dh

2223: and adj.source_type_code = 'DEPRECIATION'
2224: and adj.adjustment_type in ('EXPENSE', 'BONUS EXPENSE', 'IMPAIR EXPENSE')
2225: and adj.distribution_id in
2226: (select dh.distribution_id
2227: from fa_distribution_history dh
2228: where dh.transaction_header_id_out = X_th_id)
2229: and exists
2230: (select adj1.transaction_header_id
2231: from fa_mc_adjustments adj1

Line 2250: from fa_distribution_history dh

2246: and adj.source_type_code = 'DEPRECIATION'
2247: and adj.adjustment_type in ('EXPENSE', 'BONUS EXPENSE', 'IMPAIR EXPENSE')
2248: and adj.distribution_id in
2249: (select dh.distribution_id
2250: from fa_distribution_history dh
2251: where dh.transaction_header_id_out = X_th_id)
2252: and exists
2253: (select adj1.transaction_header_id
2254: from fa_adjustments adj1