APPS.FA_POLISH_PVT dependencies on FA_DEPRN_PERIODS

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 361: from fa_deprn_periods dp,

357: fy.start_date and fy.end_date;
358:
359: select dp.period_counter
360: into l_first_period_counter
361: from fa_deprn_periods dp,
362: fa_books bks
363: where dp.book_type_code = p_Book_Type_Code
364: and bks.book_type_code = p_Book_Type_Code
365: and bks.asset_id = p_Asset_Id

Line 372: from fa_deprn_periods

368: dp.calendar_period_open_date and dp.calendar_period_close_date;
369:
370: select period_counter
371: into l_open_period_counter
372: from fa_deprn_periods
373: where book_type_code = p_Book_Type_Code
374: and period_close_date is null;
375:
376: end if;

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 685: from fa_deprn_periods

681: when no_data_found then
682:
683: select min(period_counter)
684: into l_min_period_counter
685: from fa_deprn_periods
686: where book_type_code = p_Book_Type_Code;
687:
688: if (l_prev_year_period_counter >= l_min_period_counter) then
689:

Line 703: fa_deprn_periods dp

699: and bks.rowid =
700: (
701: select max(bks1.rowid)
702: from fa_books bks1,
703: fa_deprn_periods dp
704: where bks1.book_type_code = p_Book_Type_Code
705: and bks1.asset_id = p_Asset_Id
706: and bks1.book_type_code = dp.book_type_code
707: 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 1229: from fa_deprn_periods

1225: calendar_period_open_date and calendar_period_close_date;
1226: else
1227: select period_counter - 1
1228: into x_bef_trxn_period_counter
1229: from fa_deprn_periods
1230: where book_type_code = p_Book_Type_Code
1231: and l_amortization_start_date between
1232: calendar_period_open_date and calendar_period_close_date;
1233: end if;

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 1329: from fa_deprn_periods dp,

1325: else
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

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 1360: from fa_deprn_periods dp,

1356: else
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

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 1499: from fa_deprn_periods

1495: when no_data_found then
1496:
1497: select min(period_counter)
1498: into l_min_period_counter
1499: from fa_deprn_periods
1500: where book_type_code = p_Book_Type_Code;
1501:
1502: if (x_bef_trxn_period_counter >= l_min_period_counter) then
1503:

Line 1517: fa_deprn_periods dp

1513: and bks.rowid =
1514: (
1515: select max(bks1.rowid)
1516: from fa_books bks1,
1517: fa_deprn_periods dp
1518: where bks1.book_type_code = p_Book_Type_Code
1519: and bks1.asset_id = p_Asset_Id
1520: and bks1.book_type_code = dp.book_type_code
1521: 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 1605: from fa_deprn_periods dp,

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

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

Line 1741: from fa_deprn_periods

1737: when no_data_found then
1738:
1739: select min(period_counter)
1740: into l_min_period_counter
1741: from fa_deprn_periods
1742: where book_type_code = p_Book_Type_Code;
1743:
1744: if (x_bef_trxn_period_counter >= l_min_period_counter) then
1745:

Line 1759: fa_deprn_periods dp

1755: and bks.rowid =
1756: (
1757: select max(bks1.rowid)
1758: from fa_books bks1,
1759: fa_deprn_periods dp
1760: where bks1.book_type_code = p_Book_Type_Code
1761: and bks1.asset_id = p_Asset_Id
1762: and bks1.book_type_code = dp.book_type_code
1763: and dp.period_counter = x_bef_trxn_period_counter