APPS.PA_PROJECT_ASSETS_PUB dependencies on FA_BOOK_CONTROLS

Line 179: FROM fa_book_controls fb,

175:
176: --Used to determine if the book type code is valid for the current SOB
177: CURSOR book_type_code_cur IS
178: SELECT 'Book Type Code is valid'
179: FROM fa_book_controls fb,
180: pa_implementations pi
181: WHERE fb.set_of_books_id = pi.set_of_books_id
182: AND fb.book_type_code = p_book_type_code
183: AND fb.book_class = 'CORPORATE';

Line 2978: FROM fa_book_controls fb,

2974:
2975: --Used to determine if the book type code is valid for the current SOB
2976: CURSOR book_type_code_cur IS
2977: SELECT 'Book Type Code is valid'
2978: FROM fa_book_controls fb,
2979: pa_implementations pi
2980: WHERE fb.set_of_books_id = pi.set_of_books_id
2981: AND fb.book_type_code = p_book_type_code
2982: AND fb.book_class = 'CORPORATE';

Line 3004: l_book_type_code FA_BOOK_CONTROLS.book_type_code%TYPE;

3000:
3001: asset_category_rec asset_category_cur%ROWTYPE;
3002:
3003:
3004: l_book_type_code FA_BOOK_CONTROLS.book_type_code%TYPE;
3005: l_date_placed_in_service DATE;
3006: l_estimated_in_service_date DATE;
3007: l_depreciate_flag FA_CATEGORY_BOOK_DEFAULTS.depreciate_flag%TYPE := NULL;
3008: l_amortize_flag FA_BOOK_CONTROLS.amortize_flag%TYPE := NULL;

Line 3008: l_amortize_flag FA_BOOK_CONTROLS.amortize_flag%TYPE := NULL;

3004: l_book_type_code FA_BOOK_CONTROLS.book_type_code%TYPE;
3005: l_date_placed_in_service DATE;
3006: l_estimated_in_service_date DATE;
3007: l_depreciate_flag FA_CATEGORY_BOOK_DEFAULTS.depreciate_flag%TYPE := NULL;
3008: l_amortize_flag FA_BOOK_CONTROLS.amortize_flag%TYPE := NULL;
3009:
3010:
3011: --Used to determine if Parent Asset ID is valid in Oracle Assets
3012: CURSOR parent_asset_cur IS