APPS.FA_INTERCO_PVT dependencies on FA_DISTRIBUTION_HISTORY

Line 294: fa_distribution_history dh,

290: ''CR'', adjustment_amount,
291: adjustment_amount * -1),
292: 0)) ' ||
293: ' from fa_adjustments adj,
294: fa_distribution_history dh,
295: gl_code_combinations glcc1,
296: gl_code_combinations glcc2
297: where adj.asset_id = :p_asset_id
298: and adj.book_type_code = :p_book

Line 407: fa_distribution_history dh,

403: ''DR'', adjustment_amount,
404: adjustment_amount * -1),
405: 0)) ' ||
406: ' from fa_adjustments adj,
407: fa_distribution_history dh,
408: gl_code_combinations glcc1,
409: gl_code_combinations glcc2
410: where adj.asset_id = :p_asset_id
411: and adj.book_type_code = :p_book

Line 958: fa_distribution_history dh,

954: dh.distribution_id,
955: dh.code_combination_id,
956: dh.units_assigned
957: from fa_adjustments adj,
958: fa_distribution_history dh,
959: gl_code_combinations glcc
960: where adj.asset_id = :p_asset_id
961: and adj.book_type_code = :p_book_type_code
962: and adj.period_counter_created = :p_period_counter_created

Line 1164: from fa_distribution_history

1160: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN is
1161:
1162: CURSOR c_asset_distributions IS
1163: select code_combination_id
1164: from fa_distribution_history
1165: where asset_id = p_asset_hdr_rec.asset_id
1166: and date_ineffective is null;
1167:
1168: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

Line 1300: from fa_distribution_history

1296:
1297: if l_asset_dist_tbl(l_dist_tbl_count).expense_ccid is null then
1298: select code_combination_id
1299: into l_ccid
1300: from fa_distribution_history
1301: where distribution_id = l_asset_dist_tbl(l_dist_tbl_count).distribution_id;
1302: else
1303: l_ccid := l_asset_dist_tbl(l_dist_tbl_count).expense_ccid;
1304: end if;

Line 1377: fa_distribution_history dh

1373: 'select distinct glcc.' || l_column_name ||
1374: ' from gl_code_combinations glcc,
1375: fa_books bk,
1376: fa_book_controls bc,
1377: fa_distribution_history dh
1378: where bk.asset_id = dh.asset_id
1379: and bk.group_asset_id = :p_asset_id
1380: and bk.book_type_code = bc.book_type_code
1381: and bc.distribution_source_book = :p_book

Line 1404: fa_distribution_history dh

1400: l_statement :=
1401: 'select distinct glcc.' || l_column_name ||
1402: ' from gl_code_combinations glcc,
1403: fa_book_controls bc,
1404: fa_distribution_history dh
1405: where dh.asset_id = :p_asset_Id
1406: and dh.date_ineffective is null
1407: and dh.code_combination_id = glcc.code_combination_id
1408: and bc.distribution_source_book = :p_book

Line 1422: fa_distribution_history dh,

1418: l_statement :=
1419: 'select distinct glcc.' || l_column_name ||
1420: ' from gl_code_combinations glcc,
1421: fa_books bk,
1422: fa_distribution_history dh,
1423: fa_book_controls bc
1424: where dh.asset_id = bk.group_asset_id
1425: and dh.date_ineffective is null
1426: and dh.code_combination_id = glcc.code_combination_id

Line 1516: from fa_distribution_history

1512: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN is
1513:
1514: CURSOR c_asset_distributions (p_asset_id number) IS
1515: select code_combination_id
1516: from fa_distribution_history
1517: where asset_id = p_asset_id
1518: and date_ineffective is null;
1519:
1520: TYPE l_bal_tbl_type is table of varchar2(30) index by binary_integer;