APPS.FA_CALC_DEPRN_BASIS1_PKG dependencies on FA_MC_BOOK_CONTROLS

Line 1532: FA_MC_BOOK_CONTROLS mbc,

1528: dp.calendar_period_open_date cp_start_date,
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

Line 2804: FA_MC_BOOK_CONTROLS BC

2800: (select max(BK.TRANSACTION_HEADER_ID_IN)
2801: from FA_MC_BOOKS BK,
2802: FA_TRANSACTION_HEADERS TH,
2803: FA_CALENDAR_PERIODS CP,
2804: FA_MC_BOOK_CONTROLS BC
2805: where BK.ASSET_ID= p_asset_id
2806: and BK.BOOK_TYPE_CODE = p_book_type_code
2807: and BK.TRANSACTION_HEADER_ID_IN =TH.TRANSACTION_HEADER_ID
2808: and BK.ASSET_ID= TH.ASSET_ID

Line 3134: FA_MC_BOOK_CONTROLS MBC,

3130: cursor C_GET_NPFY_MRC
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

Line 4139: FA_MC_BOOK_CONTROLS mbc,

4135: select fy.start_date fy_start_date,
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

Line 4416: FA_MC_BOOK_CONTROLS MBC,

4412: CP.END_DATE
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