eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JL_ZZ_FA_FUNCTIONS_PKG dependencies on FA_DEPRN_PERIODS

Line 275: fa_deprn_periods dp ,

271: INTO l_transaction_header_id,
272: l_period_counter
273: FROM fa_books fb ,
274: fa_calendar_periods cp ,
275: fa_deprn_periods dp ,
276: fa_transaction_headers th ,
277: fa_asset_history ah ,
278: fa_additions ad ,
279: fa_book_controls bc

Line 303: fa_deprn_periods_mrc_v dp ,

299: SELECT fb.cost
300: INTO p_asset_cost
301: FROM fa_books_mrc_v fb ,
302: fa_calendar_periods cp ,
303: fa_deprn_periods_mrc_v dp ,
304: fa_transaction_headers th ,
305: fa_asset_history ah ,
306: fa_additions ad ,
307: fa_book_controls_mrc_v bc

Line 331: fa_deprn_periods dp ,

327: SELECT fb.cost
328: INTO p_asset_cost
329: FROM fa_books fb ,
330: fa_calendar_periods cp ,
331: fa_deprn_periods dp ,
332: fa_transaction_headers th ,
333: fa_asset_history ah ,
334: fa_additions ad ,
335: fa_book_controls bc

Line 523: fa_deprn_periods_mrc_v dp

519: BEGIN
520: SELECT nvl(bk.cost,0)
521: INTO p_historical_cost_begin_period
522: FROM fa_books_mrc_v bk,
523: fa_deprn_periods_mrc_v dp
524: WHERE bk.book_type_code = p_hist_book_type_code
525: AND bk.asset_id = p_asset_id
526: AND bk.book_type_code = dp.book_type_code
527: AND dp.period_open_date between bk.date_effective and nvl(bk.date_ineffective,dp.period_open_date)

Line 597: fa_deprn_periods_mrc_v dp

593: BEGIN
594: SELECT nvl(bk.cost,0)
595: INTO p_historical_cost_end_period
596: FROM fa_books_mrc_v bk,
597: fa_deprn_periods_mrc_v dp
598: WHERE bk.book_type_code = p_hist_book_type_code
599: AND bk.asset_id = p_asset_id
600: AND bk.book_type_code = dp.book_type_code
601: AND dp.period_close_date between bk.date_effective and nvl(bk.date_ineffective,dp.period_close_date)

Line 612: fa_deprn_periods_mrc_v dp

608: BEGIN
609: SELECT nvl(bk.cost,0)
610: INTO p_adjusted_cost_end_period
611: FROM fa_books_mrc_v bk,
612: fa_deprn_periods_mrc_v dp
613: WHERE bk.book_type_code = p_adj_book_type_code
614: AND bk.asset_id = p_asset_id
615: AND bk.book_type_code = dp.book_type_code
616: AND dp.period_close_date between bk.date_effective and nvl(bk.date_ineffective,dp.period_close_date)

Line 738: fa_deprn_periods dp

734: BEGIN
735: SELECT nvl(bk.cost,0)
736: INTO p_historical_cost_begin_period
737: FROM fa_books bk,
738: fa_deprn_periods dp
739: WHERE bk.book_type_code = p_hist_book_type_code
740: AND bk.asset_id = p_asset_id
741: AND bk.book_type_code = dp.book_type_code
742: AND dp.period_open_date between bk.date_effective and nvl(bk.date_ineffective,dp.period_open_date)

Line 830: fa_deprn_periods dp

826: BEGIN
827: SELECT nvl(bk.cost,0)
828: INTO p_historical_cost_end_period
829: FROM fa_books bk,
830: fa_deprn_periods dp
831: WHERE bk.book_type_code = p_hist_book_type_code
832: AND bk.asset_id = p_asset_id
833: AND bk.book_type_code = dp.book_type_code
834: AND dp.period_close_date between bk.date_effective and nvl(bk.date_ineffective,dp.period_close_date)

Line 845: fa_deprn_periods dp

841: BEGIN
842: SELECT nvl(bk.cost,0)
843: INTO p_adjusted_cost_end_period
844: FROM fa_books bk,
845: fa_deprn_periods dp
846: WHERE bk.book_type_code = p_adj_book_type_code
847: AND bk.asset_id = p_asset_id
848: AND bk.book_type_code = dp.book_type_code
849: AND dp.period_close_date between bk.date_effective and nvl(bk.date_ineffective,dp.period_close_date)

Line 962: fa_deprn_periods dp

958: BEGIN
959: SELECT ah.category_id
960: INTO l_category_id
961: FROM fa_asset_history ah,
962: fa_deprn_periods dp
963: WHERE ah.asset_id = p_asset_id
964: AND dp.book_type_code = p_adj_book_type_code
965: AND dp.period_counter = p_period_counter_from
966: AND dp.period_close_date between ah.date_effective and nvl(ah.date_ineffective, dp.period_close_date);

Line 988: fa_deprn_periods dp

984: BEGIN
985: SELECT rev.reval_date
986: INTO l_reval_date
987: FROM fa_mass_revaluations rev,
988: fa_deprn_periods dp
989: WHERE dp.period_counter = p_period_counter_from
990: AND dp.book_type_code = p_adj_book_type_code
991: AND dp.book_type_code = rev.book_type_code
992: AND dp.calendar_period_open_date <= rev.reval_date

Line 1013: fa_deprn_periods dp

1009: BEGIN
1010: SELECT max(rev.reval_date)
1011: INTO l_reval_date
1012: FROM fa_mass_revaluations rev,
1013: fa_deprn_periods dp
1014: WHERE dp.period_counter between p_period_counter_from and p_period_counter_to
1015: AND dp.book_type_code = p_adj_book_type_code
1016: AND dp.book_type_code = rev.book_type_code
1017: AND dp.calendar_period_open_date <= rev.reval_date

Line 1589: l_period_counter_old fa_deprn_periods.period_counter%type;

1585: -- Bug 4956193. Variables added to add logic to support multiple Adjustments in same period.
1586:
1587: l_book_type_code_old fa_transaction_headers.book_type_code%type;
1588: l_asset_id_old fa_transaction_headers.asset_id%type;
1589: l_period_counter_old fa_deprn_periods.period_counter%type;
1590: l_transaction_type_code_old fa_transaction_headers.transaction_type_code%type;
1591: l_adj_already_calculated_flag varchar2(1);
1592:
1593: -- Create ref cursors for bug 3101070

Line 1598: period_counter fa_deprn_periods.period_counter%type,

1594: Type report_row IS RECORD
1595: (
1596: asset_id fa_transaction_headers.asset_id%type,
1597: category_id fa_asset_history.category_id%type,
1598: period_counter fa_deprn_periods.period_counter%type,
1599: book_type_code fa_transaction_headers.book_type_code%type,
1600: transaction_type_code fa_transaction_headers.transaction_type_code%type,
1601: transaction_header_id fa_transaction_headers.transaction_header_id%type,
1602: asset_type fa_asset_history.asset_type%type,

Line 1657: fa_deprn_periods_mrc_v dp,

1653: th.transaction_header_id,
1654: ah.asset_type,
1655: nvl (ah.units,0)
1656: FROM fa_transaction_headers th,
1657: fa_deprn_periods_mrc_v dp,
1658: fa_asset_history ah
1659: WHERE dp.book_type_code = p_corp_book
1660: AND dp.period_counter between p_period_counter_from and p_period_counter_to
1661: AND th.book_type_code = dp.book_type_code

Line 1693: fa_deprn_periods_mrc_v dp,

1689: -1,
1690: ah.asset_type,
1691: nvl (ah.units,0)
1692: FROM fa_books bk,
1693: fa_deprn_periods_mrc_v dp,
1694: fa_asset_history ah
1695: WHERE dp.book_type_code = p_corp_book
1696: AND bk.book_type_code = dp.book_type_code
1697: AND bk.asset_id = ah.asset_id

Line 1713: fa_deprn_periods dp,

1709: th.transaction_header_id,
1710: ah.asset_type,
1711: nvl (ah.units,0)
1712: FROM fa_transaction_headers th,
1713: fa_deprn_periods dp,
1714: fa_asset_history ah
1715: WHERE dp.book_type_code = p_corp_book
1716: AND dp.period_counter between p_period_counter_from and p_period_counter_to
1717: AND th.book_type_code = dp.book_type_code

Line 1749: fa_deprn_periods dp,

1745: -1,
1746: ah.asset_type,
1747: nvl (ah.units,0)
1748: FROM fa_books bk,
1749: fa_deprn_periods dp,
1750: fa_asset_history ah
1751: WHERE dp.book_type_code = p_corp_book
1752: AND bk.book_type_code = dp.book_type_code
1753: AND bk.asset_id = ah.asset_id

Line 1929: fa_deprn_periods dp

1925: BEGIN
1926: SELECT ah.category_id
1927: INTO l_current_category_id
1928: FROM fa_asset_history ah,
1929: fa_deprn_periods dp
1930: WHERE ah.asset_id = asset_txns_rec.asset_id
1931: AND dp.book_type_code = p_corp_book
1932: AND dp.period_close_date between ah.date_effective and nvl(ah.date_ineffective,dp.period_close_date)
1933: AND dp.period_counter = p_period_counter_to;

Line 2043: fa_deprn_periods dp

2039: AND ret.transaction_header_id_in = asset_txns_rec.transaction_header_id
2040: AND ret.status = 'DELETED'
2041: AND EXISTS (SELECT th.transaction_header_id
2042: FROM fa_transaction_headers th,
2043: fa_deprn_periods dp
2044: WHERE dp.book_type_code = asset_txns_rec.book_type_code
2045: AND dp.period_counter between p_period_counter_from and p_period_counter_to
2046: AND th.book_type_code = dp.book_type_code
2047: AND dp.period_open_date <= th.date_effective

Line 2115: fa_deprn_periods dp

2111: AND ret.transaction_header_id_out = asset_txns_rec.transaction_header_id
2112: AND ret.status = 'DELETED'
2113: AND EXISTS (SELECT th.transaction_header_id
2114: FROM fa_transaction_headers th,
2115: fa_deprn_periods dp
2116: WHERE dp.book_type_code = asset_txns_rec.book_type_code
2117: AND dp.period_counter between p_period_counter_from and p_period_counter_to
2118: AND th.book_type_code = dp.book_type_code
2119: AND dp.period_open_date <= th.date_effective