[Home] [Help]
440: fy.start_date and fy.end_date;
441:
442: select dp.period_counter
443: into l_first_period_counter
444: from fa_mc_deprn_periods dp,
445: fa_mc_books bks
446: where dp.book_type_code = p_Book_Type_Code
447: and dp.set_of_books_id = p_set_of_books_id
448: and bks.book_type_code = p_Book_Type_Code
453: dp.calendar_period_open_date and dp.calendar_period_close_date;
454:
455: select period_counter
456: into l_open_period_counter
457: from fa_mc_deprn_periods
458: where book_type_code = p_Book_Type_Code
459: and period_close_date is null
460: and set_of_books_id = p_set_of_books_id;
461:
707: when no_data_found then
708:
709: select min(period_counter)
710: into l_min_period_counter
711: from fa_mc_deprn_periods
712: where book_type_code = p_Book_Type_Code
713: and set_of_books_id = p_set_of_books_id;
714:
715: if (l_prev_year_period_counter >= l_min_period_counter) then
727: and bks.rowid =
728: (
729: select max(bks1.rowid)
730: from fa_mc_books bks1,
731: fa_mc_deprn_periods dp
732: where bks1.book_type_code = p_Book_Type_Code
733: and bks1.asset_id = p_Asset_Id
734: and bks1.book_type_code = dp.book_type_code
735: and bks1.set_of_books_id = p_set_of_books_id
1363: if (p_mrc_sob_type_code = 'R') then
1364:
1365: select period_counter - 1
1366: into x_bef_trxn_period_counter
1367: from fa_mc_deprn_periods
1368: where book_type_code = p_Book_Type_Code
1369: and set_of_books_id = p_set_of_books_id
1370: and l_amortization_start_date between
1371: calendar_period_open_date and calendar_period_close_date;
1469: if (p_MRC_SOB_Type_Code = 'R') then
1470:
1471: select dp.period_counter - 1
1472: into x_bef_trxn_period_counter
1473: from fa_mc_deprn_periods dp,
1474: fa_transaction_headers th
1475: where th.transaction_header_id = p_transaction_header_id
1476: and dp.book_type_code = p_Book_Type_Code
1477: and dp.set_of_books_id = p_set_of_books_id
1501: if (p_MRC_SOB_Type_Code = 'R') then
1502:
1503: select dp.period_counter - 1
1504: into x_bef_trxn_period_counter
1505: from fa_mc_deprn_periods dp,
1506: fa_transaction_headers th
1507: where th.transaction_header_id = p_transaction_header_id
1508: and dp.book_type_code = p_Book_Type_Code
1509: and dp.set_of_books_id = p_set_of_books_id
1564: when no_data_found then
1565:
1566: select min(period_counter)
1567: into l_min_period_counter
1568: from fa_mc_deprn_periods
1569: where book_type_code = p_Book_Type_Code
1570: and set_of_books_id = p_set_of_books_id;
1571:
1572: if (x_bef_trxn_period_counter >= l_min_period_counter) then
1584: and bks.rowid =
1585: (
1586: select max(bks1.rowid)
1587: from fa_mc_books bks1,
1588: fa_mc_deprn_periods dp
1589: where bks1.book_type_code = p_Book_Type_Code
1590: and bks1.asset_id = p_Asset_Id
1591: and bks1.book_type_code = dp.book_type_code
1592: and bks1.set_of_books_id = p_set_of_books_id
1756: and set_of_books_id = p_set_of_books_id;
1757:
1758: select dp.period_counter - 1
1759: into x_bef_trxn_period_counter
1760: from fa_mc_deprn_periods dp,
1761: fa_transaction_headers th
1762: where th.transaction_header_id = p_transaction_header_id
1763: and dp.book_type_code = p_Book_Type_Code
1764: and dp.set_of_books_id = p_set_of_books_id
1835: when no_data_found then
1836:
1837: select min(period_counter)
1838: into l_min_period_counter
1839: from fa_mc_deprn_periods
1840: where book_type_code = p_Book_Type_Code
1841: and set_of_books_id = p_set_of_books_id;
1842:
1843: if (x_bef_trxn_period_counter >= l_min_period_counter) then
1855: and bks.rowid =
1856: (
1857: select max(bks1.rowid)
1858: from fa_mc_books bks1,
1859: fa_mc_deprn_periods dp
1860: where bks1.book_type_code = p_Book_Type_Code
1861: and bks1.asset_id = p_Asset_Id
1862: and bks1.set_of_books_id = p_set_of_books_id
1863: and bks1.book_type_code = dp.book_type_code