APPS.OKL_SPLIT_ASSET_PVT dependencies on FA_CATEGORY_BOOK_DEFAULTS

Line 11848: FROM fa_category_book_defaults

11844: CURSOR l_fcbd_csr (p_book_type_code IN VARCHAR2,
11845: p_category_id IN NUMBER,
11846: p_dpis IN DATE) IS
11847: SELECT retirement_prorate_convention
11848: FROM fa_category_book_defaults
11849: WHERE book_type_code = p_book_type_code
11850: AND category_id = p_category_id
11851: AND p_dpis BETWEEN start_dpis AND NVL(end_dpis,p_dpis);
11852:

Line 11853: l_retire_prorate_convention fa_category_book_defaults.retirement_prorate_convention%TYPE;

11849: WHERE book_type_code = p_book_type_code
11850: AND category_id = p_category_id
11851: AND p_dpis BETWEEN start_dpis AND NVL(end_dpis,p_dpis);
11852:
11853: l_retire_prorate_convention fa_category_book_defaults.retirement_prorate_convention%TYPE;
11854:
11855: --Bug# 3156924 :
11856: l_calling_interface CONSTANT VARCHAR2(30) := 'OKLRSPAB:Split Asset';
11857: --Bug# 4028371