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 1391: FA_BOOK_CONTROLS bc

1387: dp.calendar_period_open_date cp_start_date,
1388: dp.calendar_period_close_date cp_end_date
1389: from FA_FISCAL_YEAR fy,
1390: FA_DEPRN_PERIODS dp,
1391: FA_BOOK_CONTROLS bc
1392: where bc.book_type_code = dp.book_type_code
1393: and fy.fiscal_year = dp.fiscal_year
1394: and bc.fiscal_year_name = fy.fiscal_year_name
1395: and dp.book_type_code= p_book_type_code

Line 1407: FA_BOOK_CONTROLS_MRC_V bc

1403: dp.calendar_period_open_date cp_start_date,
1404: dp.calendar_period_close_date cp_end_date
1405: from FA_FISCAL_YEAR fy,
1406: FA_DEPRN_PERIODS_MRC_V dp,
1407: FA_BOOK_CONTROLS_MRC_V bc
1408: where bc.book_type_code = dp.book_type_code
1409: and fy.fiscal_year = dp.fiscal_year
1410: and bc.fiscal_year_name = fy.fiscal_year_name
1411: and dp.book_type_code= p_book_type_code

Line 2554: FA_BOOK_CONTROLS_MRC_V BC

2550: (select max(BK.TRANSACTION_HEADER_ID_IN)
2551: from FA_BOOKS_MRC_V BK,
2552: FA_TRANSACTION_HEADERS TH,
2553: FA_CALENDAR_PERIODS CP,
2554: FA_BOOK_CONTROLS_MRC_V BC
2555: where BK.ASSET_ID= p_asset_id
2556: and BK.BOOK_TYPE_CODE = p_book_type_code
2557: and BK.TRANSACTION_HEADER_ID_IN =TH.TRANSACTION_HEADER_ID
2558: and BK.ASSET_ID= TH.ASSET_ID

Line 2584: FA_BOOK_CONTROLS BC

2580: select CP.END_DATE
2581: from FA_CALENDAR_PERIODS CP,
2582: FA_CALENDAR_TYPES CT,
2583: FA_FISCAL_YEAR FY,
2584: FA_BOOK_CONTROLS BC
2585: where BC.DEPRN_CALENDAR = CP.CALENDAR_TYPE
2586: and CP.CALENDAR_TYPE = CT.CALENDAR_TYPE
2587: and CT.FISCAL_YEAR_NAME = FY.FISCAL_YEAR_NAME
2588: and CP.END_DATE <= FY.END_DATE

Line 2599: FA_BOOK_CONTROLS_MRC_V BC

2595: select CP.END_DATE
2596: from FA_CALENDAR_PERIODS CP,
2597: FA_CALENDAR_TYPES CT,
2598: FA_FISCAL_YEAR FY,
2599: FA_BOOK_CONTROLS_MRC_V BC
2600: where BC.DEPRN_CALENDAR = CP.CALENDAR_TYPE
2601: and CP.CALENDAR_TYPE = CT.CALENDAR_TYPE
2602: and CT.FISCAL_YEAR_NAME = FY.FISCAL_YEAR_NAME
2603: and CP.END_DATE <= FY.END_DATE

Line 2898: FA_BOOK_CONTROLS BC

2894: cursor C_GET_NPFY
2895: is
2896: select CT.number_per_fiscal_year
2897: from FA_CALENDAR_TYPES CT,
2898: FA_BOOK_CONTROLS BC
2899: where BC.DEPRN_CALENDAR = CT.CALENDAR_TYPE
2900: and BC.BOOK_TYPE_CODE= p_book_type_code;
2901:
2902: cursor C_GET_NPFY_MRC

Line 2906: FA_BOOK_CONTROLS_MRC_V BC

2902: cursor C_GET_NPFY_MRC
2903: is
2904: select CT.number_per_fiscal_year
2905: from FA_CALENDAR_TYPES CT,
2906: FA_BOOK_CONTROLS_MRC_V BC
2907: where BC.DEPRN_CALENDAR = CT.CALENDAR_TYPE
2908: and BC.BOOK_TYPE_CODE= p_book_type_code;
2909:
2910: CURSOR c_get_bs_amounts(c_period_counter number) IS

Line 3703: FA_BOOK_CONTROLS bc

3699: select fy.start_date fy_start_date,
3700: dp.calendar_period_close_date cp_end_date
3701: from FA_FISCAL_YEAR fy,
3702: FA_DEPRN_PERIODS dp,
3703: FA_BOOK_CONTROLS bc
3704: where bc.book_type_code = dp.book_type_code
3705: and fy.fiscal_year = dp.fiscal_year
3706: and bc.fiscal_year_name = fy.fiscal_year_name
3707: and dp.book_type_code= p_book_type_code

Line 3715: FA_BOOK_CONTROLS_MRC_V bc

3711: select fy.start_date fy_start_date,
3712: dp.calendar_period_close_date cp_end_date
3713: from FA_FISCAL_YEAR fy,
3714: FA_DEPRN_PERIODS_MRC_V dp,
3715: FA_BOOK_CONTROLS_MRC_V bc
3716: where bc.book_type_code = dp.book_type_code
3717: and fy.fiscal_year = dp.fiscal_year
3718: and bc.fiscal_year_name = fy.fiscal_year_name
3719: and dp.book_type_code= p_book_type_code

Line 3970: FA_BOOK_CONTROLS BC

3966: CP.END_DATE
3967: from FA_CALENDAR_PERIODS CP,
3968: FA_CALENDAR_TYPES CT,
3969: FA_FISCAL_YEAR FY,
3970: FA_BOOK_CONTROLS BC
3971: where BC.DEPRN_CALENDAR = CP.CALENDAR_TYPE
3972: and CP.CALENDAR_TYPE = CT.CALENDAR_TYPE
3973: and CT.FISCAL_YEAR_NAME = FY.FISCAL_YEAR_NAME
3974: and CP.END_DATE <= FY.END_DATE

Line 3986: FA_BOOK_CONTROLS_MRC_V BC

3982: CP.END_DATE
3983: from FA_CALENDAR_PERIODS CP,
3984: FA_CALENDAR_TYPES CT,
3985: FA_FISCAL_YEAR FY,
3986: FA_BOOK_CONTROLS_MRC_V BC
3987: where BC.DEPRN_CALENDAR = CP.CALENDAR_TYPE
3988: and CP.CALENDAR_TYPE = CT.CALENDAR_TYPE
3989: and CT.FISCAL_YEAR_NAME = FY.FISCAL_YEAR_NAME
3990: and CP.END_DATE <= FY.END_DATE