APPS.JL_CO_FA_TA_REVAL_PKG dependencies on FA_DISTRIBUTION_HISTORY

Line 37: p_distribution_id fa_distribution_history.distribution_id%TYPE,

33: p_book_type_code VARCHAR2,
34: p_asset_id NUMBER,
35: p_adjustment_amount NUMBER,
36: p_period_counter NUMBER,
37: p_distribution_id fa_distribution_history.distribution_id%TYPE,
38: p_je_category_name VARCHAR2,
39: p_reference VARCHAR2);
40:
41: PROCEDURE find_who_columns;

Line 172: FROM fa_distribution_history

168: SELECT distribution_id,
169: units_assigned,
170: code_combination_id,
171: transaction_units
172: FROM fa_distribution_history
173: WHERE book_type_code = p_book_type
174: AND transaction_header_id_out IS NULL
175: AND date_ineffective IS NULL
176: AND asset_id = p_asset_id;

Line 1559: p_distribution_id fa_distribution_history.distribution_id%TYPE,

1555: p_book_type_code VARCHAR2,
1556: p_asset_id NUMBER,
1557: p_adjustment_amount NUMBER,
1558: p_period_counter NUMBER,
1559: p_distribution_id fa_distribution_history.distribution_id%TYPE,
1560: P_je_category_name VARCHAR2,
1561: p_reference VARCHAR2) IS
1562:
1563: x_period_counter NUMBER;