APPS.OKL_SPLIT_ASSET_PVT dependencies on FA_CATEGORY_BOOK_DEFAULTS

Line 11901: FROM fa_category_book_defaults

11897: CURSOR l_fcbd_csr (p_book_type_code IN VARCHAR2,
11898: p_category_id IN NUMBER,
11899: p_dpis IN DATE) IS
11900: SELECT retirement_prorate_convention
11901: FROM fa_category_book_defaults
11902: WHERE book_type_code = p_book_type_code
11903: AND category_id = p_category_id
11904: AND p_dpis BETWEEN start_dpis AND NVL(end_dpis,p_dpis);
11905:

Line 11906: l_retire_prorate_convention fa_category_book_defaults.retirement_prorate_convention%TYPE;

11902: WHERE book_type_code = p_book_type_code
11903: AND category_id = p_category_id
11904: AND p_dpis BETWEEN start_dpis AND NVL(end_dpis,p_dpis);
11905:
11906: l_retire_prorate_convention fa_category_book_defaults.retirement_prorate_convention%TYPE;
11907:
11908: --Bug# 3156924 :
11909: l_calling_interface CONSTANT VARCHAR2(30) := 'OKLRSPAB:Split Asset';
11910: --Bug# 4028371