APPS.FA_POLISH_PVT dependencies on FA_TRANSACTION_HEADERS

Line 453: -- adjustment in fa_transaction_headers or fa_adjustments.

449:
450: if (FA_POLISH_PVT.calling_mode = 'ADJUSTMENT') then
451: -- If we are currently doing an adjustment, no rows for the adjustment
452: -- will be been added yet, so there will not exist rows for the
453: -- adjustment in fa_transaction_headers or fa_adjustments.
454: l_transaction_type_code := 'ADJUSTMENT';
455:
456: else
457:

Line 470: from fa_transaction_headers

466: select transaction_type_code,
467: transaction_header_id
468: into l_transaction_type_code,
469: l_transaction_header_id
470: from fa_transaction_headers
471: where book_type_code = p_Book_Type_Code
472: and asset_id = p_Asset_ID
473: and transaction_type_code in ('ADJUSTMENT', 'PARTIAL RETIREMENT')
474: and transaction_header_id =

Line 477: from fa_transaction_headers

473: and transaction_type_code in ('ADJUSTMENT', 'PARTIAL RETIREMENT')
474: and transaction_header_id =
475: (
476: select max(transaction_header_id)
477: from fa_transaction_headers
478: where book_type_code = p_Book_Type_Code
479: and asset_id = p_Asset_ID
480: and transaction_type_code in ('ADJUSTMENT', 'PARTIAL RETIREMENT')
481: );

Line 1319: fa_transaction_headers th

1315:
1316: select dp.period_counter - 1
1317: into x_bef_trxn_period_counter
1318: from fa_deprn_periods_mrc_v dp,
1319: fa_transaction_headers th
1320: where th.transaction_header_id = p_transaction_header_id
1321: and dp.book_type_code = p_Book_Type_Code
1322: and th.date_effective between
1323: dp.period_open_date and

Line 1330: fa_transaction_headers th

1326:
1327: select dp.period_counter - 1
1328: into x_bef_trxn_period_counter
1329: from fa_deprn_periods dp,
1330: fa_transaction_headers th
1331: where th.transaction_header_id = p_transaction_header_id
1332: and dp.book_type_code = p_Book_Type_Code
1333: and th.date_effective between
1334: dp.period_open_date and

Line 1350: fa_transaction_headers th

1346:
1347: select dp.period_counter - 1
1348: into x_bef_trxn_period_counter
1349: from fa_deprn_periods_mrc_v dp,
1350: fa_transaction_headers th
1351: where th.transaction_header_id = p_transaction_header_id
1352: and dp.book_type_code = p_Book_Type_Code
1353: and th.transaction_date_entered between
1354: dp.calendar_period_open_date and

Line 1361: fa_transaction_headers th

1357:
1358: select dp.period_counter - 1
1359: into x_bef_trxn_period_counter
1360: from fa_deprn_periods dp,
1361: fa_transaction_headers th
1362: where th.transaction_header_id = p_transaction_header_id
1363: and dp.book_type_code = p_Book_Type_Code
1364: and th.transaction_date_entered between
1365: dp.calendar_period_open_date and

Line 1584: fa_transaction_headers th

1580:
1581: select dp.period_counter - 1
1582: into x_bef_trxn_period_counter
1583: from fa_deprn_periods_mrc_v dp,
1584: fa_transaction_headers th
1585: where th.transaction_header_id = p_transaction_header_id
1586: and dp.book_type_code = p_Book_Type_Code
1587: and th.transaction_date_entered between
1588: dp.calendar_period_open_date and

Line 1606: fa_transaction_headers th

1602:
1603: select dp.period_counter - 1
1604: into x_bef_trxn_period_counter
1605: from fa_deprn_periods dp,
1606: fa_transaction_headers th
1607: where th.transaction_header_id = p_transaction_header_id
1608: and dp.book_type_code = p_Book_Type_Code
1609: and th.transaction_date_entered between
1610: dp.calendar_period_open_date and