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 883: fa_book_controls bc,

879:
880: CURSOR check_current_period_add is
881: select 'FA_RET_CANT_RET_NONDEPRN'
882: from fa_transaction_headers th,
883: fa_book_controls bc,
884: fa_deprn_periods dp
885: where th.asset_id = p_Asset_id
886: AND th.book_type_code = G_Book_Type_Code
887: AND bc.book_type_code = th.book_type_code

Line 1038: l_book_type_code fa_book_controls.book_type_code%TYPE;

1034: temp_from_dpis date;
1035: temp_to_dpis date;
1036: dml_error exception;
1037:
1038: l_book_type_code fa_book_controls.book_type_code%TYPE;
1039: l_post_units number;
1040: l_asset_post_units number;
1041: l_dist_post_units number;
1042: l_diff number;

Line 1128: FROM fa_book_controls fbc,

1124: faa.asset_number,
1125: fab.date_placed_in_service,
1126: fab.cost,
1127: faa.current_units
1128: FROM fa_book_controls fbc,
1129: fa_books fab,
1130: fa_additions_b faa
1131: WHERE faa.asset_id = fab.asset_id
1132: AND (faa.asset_key_ccid = G_Asset_Key_Id

Line 2985: fa_book_controls fbc,

2981: fmr.include_fully_rsvd_flag,
2982: fmr.group_asset_id, -- crl, no reason to break out
2983: fmr.group_association
2984: FROM fa_mass_retirements fmr,
2985: fa_book_controls fbc,
2986: gl_sets_of_books sob
2987: WHERE fmr.mass_retirement_id = p_Mass_Retirement_Id
2988: AND fmr.book_type_code = fbc.book_type_code
2989: AND fbc.set_of_books_id = sob.set_of_books_id;

Line 2999: fa_book_controls fbc,

2995: faa.asset_number,
2996: fab.cost,
2997: faa.current_units
2998: FROM fa_books fab,
2999: fa_book_controls fbc,
3000: fa_additions_b faa
3001: WHERE faa.asset_id = fab.asset_id
3002: AND (faa.asset_key_ccid = G_Asset_Key_Id
3003: OR G_Asset_Key_Id IS NULL)

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

3133: AND G_Segment30_High
3134: OR G_segment30_Low IS NULL))
3135: AND (faa.asset_type = G_Asset_Type OR G_Asset_Type IS NULL)
3136: AND faa.asset_type IN ('CIP','CAPITALIZED','EXPENSED')
3137: -- YYOON 12/13/01: Performance Bug#2134816: Changed driving table from fa_books to fa_book_controls
3138: AND fbc.book_type_code = G_Book_Type_Code
3139: --AND fab.date_ineffective IS NULL
3140: AND fab.TRANSACTION_HEADER_ID_OUT IS NULL --bug 8264324
3141: ORDER BY fab.date_placed_in_service, faa.asset_number;