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.FA_ASSET_VAL_PVT dependencies on FA_BOOK_CONTROLS

Line 943: from fa_book_controls bc

939: from fa_books bks
940: where exists
941: (
942: select 'X'
943: from fa_book_controls bc
944: where bc.book_type_code = p_book_type_code
945: and bc.distribution_source_book = bks.book_type_code
946: )
947: and bks.asset_id = p_asset_id;

Line 1010: FROM fa_calendar_periods fcp, fa_book_controls fbc

1006: BEGIN
1007:
1008: SELECT 1
1009: INTO x_same_period
1010: FROM fa_calendar_periods fcp, fa_book_controls fbc
1011: WHERE fbc.book_type_code = p_asset_hdr_rec.book_type_code
1012: AND fcp.calendar_type = fbc.deprn_calendar
1013: AND p_trans_rec.transaction_date_entered BETWEEN
1014: fcp.start_date AND fcp.end_date

Line 1324: fa_book_controls bc

1320: begin
1321: select 'x'
1322: into l_check_prorate_date
1323: from fa_calendar_periods cp,
1324: fa_book_controls bc
1325: where bc.book_type_code = p_book_type_code
1326: and bc.prorate_calendar = cp.calendar_type
1327: and l_prorate_date between cp.start_date and cp.end_date;
1328:

Line 1451: l_current_fiscal_year FA_BOOK_CONTROLS.current_fiscal_year%TYPE;

1447: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type, /*Fix for bug 8790562 */
1448: p_calling_fn IN VARCHAR2,
1449: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
1450:
1451: l_current_fiscal_year FA_BOOK_CONTROLS.current_fiscal_year%TYPE;
1452: l_fiscal_year_name FA_BOOK_CONTROLS.fiscal_year_name%TYPE;
1453:
1454: l_same_fiscal_year NUMBER;
1455: l_abs_deprn_reserve NUMBER;

Line 1452: l_fiscal_year_name FA_BOOK_CONTROLS.fiscal_year_name%TYPE;

1448: p_calling_fn IN VARCHAR2,
1449: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
1450:
1451: l_current_fiscal_year FA_BOOK_CONTROLS.current_fiscal_year%TYPE;
1452: l_fiscal_year_name FA_BOOK_CONTROLS.fiscal_year_name%TYPE;
1453:
1454: l_same_fiscal_year NUMBER;
1455: l_abs_deprn_reserve NUMBER;
1456: l_abs_ytd_deprn NUMBER;

Line 3016: fa_book_controls bc,

3012:
3013: -- Validate warranty currency is correct
3014: SELECT count(w.warranty_id) INTO l_count
3015: FROM gl_sets_of_books glsob,
3016: fa_book_controls bc,
3017: fa_warranties w
3018: WHERE w.warranty_id = p_warranty_id
3019: AND bc.book_type_code = p_book_type_code
3020: AND bc.set_of_books_id = glsob.set_of_books_id

Line 3049: fa_book_controls bc,

3045:
3046: CURSOR C1 IS
3047: select currency_code
3048: from gl_sets_of_books sob,
3049: fa_book_controls bc,
3050: fa_books bk
3051: where bk.asset_id = p_asset_id
3052: and bk.date_ineffective is null
3053: and bk.book_type_code = bc.book_type_code

Line 4615: ,fa_book_controls fbc

4611: )
4612: is
4613: select fcp.end_date
4614: from fa_fiscal_year ffy
4615: ,fa_book_controls fbc
4616: ,fa_calendar_periods fcp
4617: ,fa_calendar_types fct
4618: where ffy.fiscal_year_name = fbc.fiscal_year_name
4619: and ffy.fiscal_year_name = fct.fiscal_year_name

Line 4631: from fa_book_controls fbc

4627: cursor lcu_curr_open_period(p_book_type_code in varchar2
4628: )
4629: is
4630: select fdp.calendar_period_close_date
4631: from fa_book_controls fbc
4632: ,fa_deprn_periods fdp
4633: where fbc.book_type_code = fdp.book_type_code
4634: and fdp.period_counter = fbc.last_period_counter+1
4635: and fbc.book_type_code = p_book_type_code;

Line 4724: ,fa_book_controls fbc

4720: cursor lcu_period_info(p_book_type_code in varchar2,
4721: p_period_ctr in number) is
4722: select fcp.end_date
4723: from fa_fiscal_year ffy
4724: ,fa_book_controls fbc
4725: ,fa_calendar_periods fcp
4726: ,fa_calendar_types fct
4727: where ffy.fiscal_year_name = fbc.fiscal_year_name
4728: and ffy.fiscal_year_name = fct.fiscal_year_name

Line 4831: ,fa_book_controls fbc

4827: )
4828: is
4829: select fcp.end_date
4830: from fa_fiscal_year ffy
4831: ,fa_book_controls fbc
4832: ,fa_calendar_periods fcp
4833: ,fa_calendar_types fct
4834: where ffy.fiscal_year_name = fbc.fiscal_year_name
4835: and ffy.fiscal_year_name = fct.fiscal_year_name

Line 4847: from fa_book_controls fbc

4843: cursor lcu_curr_open_period(p_book_type_code in varchar2
4844: )
4845: is
4846: select fdp.calendar_period_close_date
4847: from fa_book_controls fbc
4848: ,fa_deprn_periods fdp
4849: where fbc.book_type_code = fdp.book_type_code
4850: and fdp.period_counter = fbc.last_period_counter+1
4851: and fbc.book_type_code = p_book_type_code;

Line 5989: from fa_book_controls fbc

5985: cursor l_curr_open_period(p_book_type_code in varchar2
5986: )
5987: is
5988: select fdp.calendar_period_close_date
5989: from fa_book_controls fbc
5990: ,fa_deprn_periods fdp
5991: where fbc.book_type_code = fdp.book_type_code
5992: and fdp.period_counter = fbc.last_period_counter+1
5993: and fbc.book_type_code = p_book_type_code;

Line 6005: ,fa_book_controls fbc

6001: ,ffy.fiscal_year
6002: ,fcp.period_num
6003: ,fct.number_per_fiscal_year
6004: from fa_fiscal_year ffy
6005: ,fa_book_controls fbc
6006: ,fa_calendar_periods fcp
6007: ,fa_calendar_types fct
6008: where ffy.fiscal_year_name = fbc.fiscal_year_name
6009: and ffy.fiscal_year_name = fct.fiscal_year_name

Line 6555: fa_book_controls bc,

6551: /* Check any tax books exists with UOP method */
6552: cursor check_tax_book_method is
6553: select 'x'
6554: from fa_books bk,
6555: fa_book_controls bc,
6556: fa_methods mth
6557: where bc.distribution_source_book = p_asset_hdr_rec.book_type_code
6558: and bc.book_class = 'TAX'
6559: and bk.book_type_code = bc.book_type_code