APPS.FA_POLISH_PVT dependencies on FA_DEPRN_PERIODS

Line 479: from fa_deprn_periods dp,

475: fy.start_date and fy.end_date;
476:
477: select dp.period_counter
478: into l_first_period_counter
479: from fa_deprn_periods dp,
480: fa_books bks
481: where dp.book_type_code = p_Book_Type_Code
482: and bks.book_type_code = p_Book_Type_Code
483: and bks.asset_id = p_Asset_Id

Line 490: from fa_deprn_periods

486: dp.calendar_period_open_date and dp.calendar_period_close_date;
487:
488: select period_counter
489: into l_open_period_counter
490: from fa_deprn_periods
491: where book_type_code = p_Book_Type_Code
492: and period_close_date is null;
493:
494: end if;

Line 829: from fa_deprn_periods

825: when no_data_found then
826:
827: select min(period_counter)
828: into l_min_period_counter
829: from fa_deprn_periods
830: where book_type_code = p_Book_Type_Code;
831:
832: if (l_prev_year_period_counter >= l_min_period_counter) then
833:

Line 847: fa_deprn_periods dp

843: and bks.rowid =
844: (
845: select max(bks1.rowid)
846: from fa_books bks1,
847: fa_deprn_periods dp
848: where bks1.book_type_code = p_Book_Type_Code
849: and bks1.asset_id = p_Asset_Id
850: and bks1.book_type_code = dp.book_type_code
851: and dp.period_counter = l_prev_year_period_counter

Line 1375: from fa_deprn_periods

1371: calendar_period_open_date and calendar_period_close_date;
1372: else
1373: select period_counter - 1
1374: into x_bef_trxn_period_counter
1375: from fa_deprn_periods
1376: where book_type_code = p_Book_Type_Code
1377: and l_amortization_start_date between
1378: calendar_period_open_date and calendar_period_close_date;
1379: end if;

Line 1485: from fa_deprn_periods dp,

1481: else
1482:
1483: select dp.period_counter - 1
1484: into x_bef_trxn_period_counter
1485: from fa_deprn_periods dp,
1486: fa_transaction_headers th
1487: where th.transaction_header_id = p_transaction_header_id
1488: and dp.book_type_code = p_Book_Type_Code
1489: and th.date_effective between

Line 1517: from fa_deprn_periods dp,

1513: else
1514:
1515: select dp.period_counter - 1
1516: into x_bef_trxn_period_counter
1517: from fa_deprn_periods dp,
1518: fa_transaction_headers th
1519: where th.transaction_header_id = p_transaction_header_id
1520: and dp.book_type_code = p_Book_Type_Code
1521: and th.transaction_date_entered between

Line 1670: from fa_deprn_periods

1666: when no_data_found then
1667:
1668: select min(period_counter)
1669: into l_min_period_counter
1670: from fa_deprn_periods
1671: where book_type_code = p_Book_Type_Code;
1672:
1673: if (x_bef_trxn_period_counter >= l_min_period_counter) then
1674:

Line 1688: fa_deprn_periods dp

1684: and bks.rowid =
1685: (
1686: select max(bks1.rowid)
1687: from fa_books bks1,
1688: fa_deprn_periods dp
1689: where bks1.book_type_code = p_Book_Type_Code
1690: and bks1.asset_id = p_Asset_Id
1691: and bks1.book_type_code = dp.book_type_code
1692: and dp.period_counter = x_bef_trxn_period_counter

Line 1784: from fa_deprn_periods dp,

1780: and adjustment_type = 'COST';
1781:
1782: select dp.period_counter - 1
1783: into x_bef_trxn_period_counter
1784: from fa_deprn_periods dp,
1785: fa_transaction_headers th
1786: where th.transaction_header_id = p_transaction_header_id
1787: and dp.book_type_code = p_Book_Type_Code
1788: and th.transaction_date_entered between

Line 1927: from fa_deprn_periods

1923: when no_data_found then
1924:
1925: select min(period_counter)
1926: into l_min_period_counter
1927: from fa_deprn_periods
1928: where book_type_code = p_Book_Type_Code;
1929:
1930: if (x_bef_trxn_period_counter >= l_min_period_counter) then
1931:

Line 1945: fa_deprn_periods dp

1941: and bks.rowid =
1942: (
1943: select max(bks1.rowid)
1944: from fa_books bks1,
1945: fa_deprn_periods dp
1946: where bks1.book_type_code = p_Book_Type_Code
1947: and bks1.asset_id = p_Asset_Id
1948: and bks1.book_type_code = dp.book_type_code
1949: and dp.period_counter = x_bef_trxn_period_counter