APPS.FA_MASS_RET_PKG dependencies on FA_BOOK_CONTROLS

Line 117: G_Book_Class fa_book_controls.book_class%TYPE;

113:
114: G_Extend_Search VARCHAR2(10);
115: G_Mode VARCHAR2(30);
116: G_batch_name VARCHAR2(30);
117: G_Book_Class fa_book_controls.book_class%TYPE;
118: G_Currency_Code gl_sets_of_books.currency_code%TYPE;
119: G_Precision NUMBER;
120: G_Ext_Precision NUMBER;
121: G_Min_Acct_Unit NUMBER;

Line 896: fa_book_controls bc,

892: /* Excluded due to SLA
893: CURSOR check_current_period_add is
894: select 'FA_RET_CANT_RET_NONDEPRN'
895: from fa_transaction_headers th,
896: fa_book_controls bc,
897: fa_deprn_periods dp
898: where th.asset_id = p_Asset_id
899: AND th.book_type_code = G_Book_Type_Code
900: AND bc.book_type_code = th.book_type_code

Line 1067: l_book_type_code fa_book_controls.book_type_code%TYPE;

1063: temp_from_dpis date;
1064: temp_to_dpis date;
1065: dml_error exception;
1066:
1067: l_book_type_code fa_book_controls.book_type_code%TYPE;
1068: l_post_units number;
1069: l_asset_post_units number;
1070: l_dist_post_units number;
1071: l_diff number;

Line 1157: FROM fa_book_controls fbc,

1153: faa.asset_number,
1154: fab.date_placed_in_service,
1155: fab.cost,
1156: faa.current_units
1157: FROM fa_book_controls fbc,
1158: fa_books fab,
1159: fa_additions_b faa
1160: WHERE faa.asset_id = fab.asset_id
1161: AND (faa.asset_key_ccid = G_Asset_Key_Id

Line 3155: fa_book_controls fbc,

3151: fmr.include_fully_rsvd_flag,
3152: fmr.group_asset_id, -- crl, no reason to break out
3153: fmr.group_association
3154: FROM fa_mass_retirements fmr,
3155: fa_book_controls fbc,
3156: gl_sets_of_books sob
3157: WHERE fmr.mass_retirement_id = p_Mass_Retirement_Id
3158: AND fmr.book_type_code = fbc.book_type_code
3159: AND fbc.set_of_books_id = sob.set_of_books_id;

Line 3168: FROM fa_book_controls fbc,

3164: faa.asset_id,
3165: faa.asset_number,
3166: fab.cost,
3167: faa.current_units
3168: FROM fa_book_controls fbc,
3169: fa_books fab,
3170: fa_additions_b faa
3171: WHERE faa.asset_id = fab.asset_id
3172: AND (faa.asset_key_ccid = G_Asset_Key_Id

Line 3307: -- YYOON 12/13/01: Performance Bug#2134816: Changed driving table from fa_books to fa_book_controls

3303: AND G_Segment30_High
3304: OR G_segment30_Low IS NULL))
3305: AND (faa.asset_type = G_Asset_Type OR G_Asset_Type IS NULL)
3306: AND faa.asset_type IN ('CIP','CAPITALIZED','EXPENSED')
3307: -- YYOON 12/13/01: Performance Bug#2134816: Changed driving table from fa_books to fa_book_controls
3308: AND fbc.book_type_code = G_Book_Type_Code
3309: AND fab.date_ineffective IS NULL
3310: ORDER BY fab.date_placed_in_service, faa.asset_number;
3311: