APPS.PA_PROJECT_ASSETS_PUB dependencies on FA_CATEGORY_BOOK_DEFAULTS

Line 218: FROM fa_category_book_defaults

214:
215: --Used to default the depreciate_flag from category book defaults
216: CURSOR depreciate_flag_cur IS
217: SELECT SUBSTR(depreciate_flag,1,1)
218: FROM fa_category_book_defaults
219: WHERE category_id = p_asset_category_id
220: AND book_type_code = l_asset_in_rec.book_type_code
221: AND NVL(p_date_placed_in_service,NVL(p_estimated_in_service_date,TRUNC(SYSDATE)))
222: BETWEEN start_dpis AND NVL(end_dpis,NVL(p_date_placed_in_service,NVL(p_estimated_in_service_date,TRUNC(SYSDATE))));

Line 3007: l_depreciate_flag FA_CATEGORY_BOOK_DEFAULTS.depreciate_flag%TYPE := NULL;

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;
3009:
3010:
3011: --Used to determine if Parent Asset ID is valid in Oracle Assets

Line 3048: FROM fa_category_book_defaults

3044:
3045: --Used to default the depreciate_flag from category book defaults
3046: CURSOR depreciate_flag_cur IS
3047: SELECT SUBSTR(depreciate_flag,1,1)
3048: FROM fa_category_book_defaults
3049: WHERE category_id = p_asset_category_id
3050: AND book_type_code = l_book_type_code
3051: AND NVL(l_date_placed_in_service,NVL(l_estimated_in_service_date,TRUNC(SYSDATE)))
3052: BETWEEN start_dpis AND NVL(end_dpis,NVL(l_date_placed_in_service,NVL(l_estimated_in_service_date,TRUNC(SYSDATE))));