DBA Data[Home] [Help]

APPS.FA_POLISH_PVT dependencies on FA_DEPRN_PERIODS_MRC_V

Line 329: from fa_deprn_periods_mrc_v dp,

325: fy.start_date and fy.end_date;
326:
327: select dp.period_counter
328: into l_first_period_counter
329: from fa_deprn_periods_mrc_v dp,
330: fa_books_mrc_v bks
331: where dp.book_type_code = p_Book_Type_Code
332: and bks.book_type_code = p_Book_Type_Code
333: and bks.asset_id = p_Asset_Id

Line 340: from fa_deprn_periods_mrc_v

336: dp.calendar_period_open_date and dp.calendar_period_close_date;
337:
338: select period_counter
339: into l_open_period_counter
340: from fa_deprn_periods_mrc_v
341: where book_type_code = p_Book_Type_Code
342: and period_close_date is null;
343:
344: else

Line 582: from fa_deprn_periods_mrc_v

578: when no_data_found then
579:
580: select min(period_counter)
581: into l_min_period_counter
582: from fa_deprn_periods_mrc_v
583: where book_type_code = p_Book_Type_Code;
584:
585: if (l_prev_year_period_counter >= l_min_period_counter) then
586:

Line 600: fa_deprn_periods_mrc_v dp

596: and bks.rowid =
597: (
598: select max(bks1.rowid)
599: from fa_books_mrc_v bks1,
600: fa_deprn_periods_mrc_v dp
601: where bks1.book_type_code = p_Book_Type_Code
602: and bks1.asset_id = p_Asset_Id
603: and bks1.book_type_code = dp.book_type_code
604: and dp.period_counter = l_prev_year_period_counter

Line 1222: from fa_deprn_periods_mrc_v

1218: if (p_mrc_sob_type_code = 'R') then
1219:
1220: select period_counter - 1
1221: into x_bef_trxn_period_counter
1222: from fa_deprn_periods_mrc_v
1223: where book_type_code = p_Book_Type_Code
1224: and l_amortization_start_date between
1225: calendar_period_open_date and calendar_period_close_date;
1226: else

Line 1318: from fa_deprn_periods_mrc_v dp,

1314: if (p_MRC_SOB_Type_Code = 'R') then
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

Line 1349: from fa_deprn_periods_mrc_v dp,

1345: if (p_MRC_SOB_Type_Code = 'R') then
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

Line 1411: from fa_deprn_periods_mrc_v

1407: when no_data_found then
1408:
1409: select min(period_counter)
1410: into l_min_period_counter
1411: from fa_deprn_periods_mrc_v
1412: where book_type_code = p_Book_Type_Code;
1413:
1414: if (x_bef_trxn_period_counter >= l_min_period_counter) then
1415:

Line 1429: fa_deprn_periods_mrc_v dp

1425: and bks.rowid =
1426: (
1427: select max(bks1.rowid)
1428: from fa_books_mrc_v bks1,
1429: fa_deprn_periods_mrc_v dp
1430: where bks1.book_type_code = p_Book_Type_Code
1431: and bks1.asset_id = p_Asset_Id
1432: and bks1.book_type_code = dp.book_type_code
1433: and dp.period_counter = x_bef_trxn_period_counter

Line 1583: from fa_deprn_periods_mrc_v dp,

1579: and adjustment_type = 'COST';
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

Line 1659: from fa_deprn_periods_mrc_v

1655: when no_data_found then
1656:
1657: select min(period_counter)
1658: into l_min_period_counter
1659: from fa_deprn_periods_mrc_v
1660: where book_type_code = p_Book_Type_Code;
1661:
1662: if (x_bef_trxn_period_counter >= l_min_period_counter) then
1663:

Line 1677: fa_deprn_periods_mrc_v dp

1673: and bks.rowid =
1674: (
1675: select max(bks1.rowid)
1676: from fa_books_mrc_v bks1,
1677: fa_deprn_periods_mrc_v dp
1678: where bks1.book_type_code = p_Book_Type_Code
1679: and bks1.asset_id = p_Asset_Id
1680: and bks1.book_type_code = dp.book_type_code
1681: and dp.period_counter = x_bef_trxn_period_counter