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_CALC_DEPRN_BASIS1_PKG dependencies on FA_BOOK_CONTROLS

Line 855: , fa_book_controls fc

851: BEGIN
852: SELECT rate_in_use, deprn_method_code,cost,nbv_at_switch -- Added deprn_method_code for bug fix 6717680
853: INTO l_rate_in_use, l_old_method_code,l_old_cost,l_nbv_at_switch
854: FROM fa_books fb
855: , fa_book_controls fc
856: WHERE fb.asset_id = g_rule_in.asset_id
857: AND fc.book_type_code = g_rule_in.book_type_code
858: AND fc.distribution_source_book = fb.book_type_code
859: AND fb.transaction_header_id_out is null;

Line 1516: FA_BOOK_CONTROLS bc

1512: dp.calendar_period_open_date cp_start_date,
1513: dp.calendar_period_close_date cp_end_date
1514: from FA_FISCAL_YEAR fy,
1515: FA_DEPRN_PERIODS dp,
1516: FA_BOOK_CONTROLS bc
1517: where bc.book_type_code = dp.book_type_code
1518: and fy.fiscal_year = dp.fiscal_year
1519: and bc.fiscal_year_name = fy.fiscal_year_name
1520: and dp.book_type_code= p_book_type_code

Line 1533: FA_BOOK_CONTROLS BC

1529: dp.calendar_period_close_date cp_end_date
1530: from FA_FISCAL_YEAR fy,
1531: FA_MC_DEPRN_PERIODS dp,
1532: FA_MC_BOOK_CONTROLS mbc,
1533: FA_BOOK_CONTROLS BC
1534: where bc.book_type_code = dp.book_type_code
1535: and mbc.book_type_code = dp.book_type_code
1536: and mbc.set_of_books_id = p_set_of_books_id
1537: and fy.fiscal_year = dp.fiscal_year

Line 2828: FA_BOOK_CONTROLS BC

2824: select CP.END_DATE
2825: from FA_CALENDAR_PERIODS CP,
2826: FA_CALENDAR_TYPES CT,
2827: FA_FISCAL_YEAR FY,
2828: FA_BOOK_CONTROLS BC
2829: where BC.DEPRN_CALENDAR = CP.CALENDAR_TYPE
2830: and CP.CALENDAR_TYPE = CT.CALENDAR_TYPE
2831: and CT.FISCAL_YEAR_NAME = FY.FISCAL_YEAR_NAME
2832: and CP.END_DATE <= FY.END_DATE

Line 2843: FA_BOOK_CONTROLS BC

2839: select CP.END_DATE
2840: from FA_CALENDAR_PERIODS CP,
2841: FA_CALENDAR_TYPES CT,
2842: FA_FISCAL_YEAR FY,
2843: FA_BOOK_CONTROLS BC
2844: where BC.DEPRN_CALENDAR = CP.CALENDAR_TYPE
2845: and BC.set_of_books_id = p_set_of_books_id
2846: and CP.CALENDAR_TYPE = CT.CALENDAR_TYPE
2847: and CT.FISCAL_YEAR_NAME = FY.FISCAL_YEAR_NAME

Line 3126: FA_BOOK_CONTROLS BC

3122: cursor C_GET_NPFY
3123: is
3124: select CT.number_per_fiscal_year
3125: from FA_CALENDAR_TYPES CT,
3126: FA_BOOK_CONTROLS BC
3127: where BC.DEPRN_CALENDAR = CT.CALENDAR_TYPE
3128: and BC.BOOK_TYPE_CODE= p_book_type_code;
3129:
3130: cursor C_GET_NPFY_MRC

Line 3135: FA_BOOK_CONTROLS BC

3131: is
3132: select CT.number_per_fiscal_year
3133: from FA_CALENDAR_TYPES CT,
3134: FA_MC_BOOK_CONTROLS MBC,
3135: FA_BOOK_CONTROLS BC
3136: where BC.DEPRN_CALENDAR = CT.CALENDAR_TYPE
3137: and BC.BOOK_TYPE_CODE= p_book_type_code
3138: and MBC.BOOK_TYPE_CODE= p_book_type_code
3139: and MBC.set_of_books_id = p_set_of_books_id;

Line 4127: FA_BOOK_CONTROLS bc

4123: select fy.start_date fy_start_date,
4124: dp.calendar_period_close_date cp_end_date
4125: from FA_FISCAL_YEAR fy,
4126: FA_DEPRN_PERIODS dp,
4127: FA_BOOK_CONTROLS bc
4128: where bc.book_type_code = dp.book_type_code
4129: and fy.fiscal_year = dp.fiscal_year
4130: and bc.fiscal_year_name = fy.fiscal_year_name
4131: and dp.book_type_code= p_book_type_code

Line 4140: FA_BOOK_CONTROLS BC

4136: dp.calendar_period_close_date cp_end_date
4137: from FA_FISCAL_YEAR fy,
4138: FA_MC_DEPRN_PERIODS dp,
4139: FA_MC_BOOK_CONTROLS mbc,
4140: FA_BOOK_CONTROLS BC
4141: where bc.book_type_code = dp.book_type_code
4142: and mbc.book_type_code = dp.book_type_code
4143: and mbc.set_of_books_id = p_set_of_books_id
4144: and fy.fiscal_year = dp.fiscal_year

Line 4400: FA_BOOK_CONTROLS BC

4396: CP.END_DATE
4397: from FA_CALENDAR_PERIODS CP,
4398: FA_CALENDAR_TYPES CT,
4399: FA_FISCAL_YEAR FY,
4400: FA_BOOK_CONTROLS BC
4401: where BC.DEPRN_CALENDAR = CP.CALENDAR_TYPE
4402: and CP.CALENDAR_TYPE = CT.CALENDAR_TYPE
4403: and CT.FISCAL_YEAR_NAME = FY.FISCAL_YEAR_NAME
4404: and CP.END_DATE <= FY.END_DATE

Line 4417: FA_BOOK_CONTROLS BC

4413: from FA_CALENDAR_PERIODS CP,
4414: FA_CALENDAR_TYPES CT,
4415: FA_FISCAL_YEAR FY,
4416: FA_MC_BOOK_CONTROLS MBC,
4417: FA_BOOK_CONTROLS BC
4418: where BC.DEPRN_CALENDAR = CP.CALENDAR_TYPE
4419: and CP.CALENDAR_TYPE = CT.CALENDAR_TYPE
4420: and CT.FISCAL_YEAR_NAME = FY.FISCAL_YEAR_NAME
4421: and CP.END_DATE <= FY.END_DATE