APPS.OKL_ACTIVATE_ASSET_PVT dependencies on FA_CATEGORY_BOOK_DEFAULTS

Line 9162: fa_category_book_defaults fcbd

9158: txl.depreciation_id,
9159: txl.kle_id
9160: from okl_txl_Assets_b txl,
9161: fa_book_controls fbc,
9162: fa_category_book_defaults fcbd
9163: where fcbd.category_id = txl.depreciation_id
9164: and fcbd.book_type_code = txl.corporate_book
9165: and txl.in_service_date between fcbd.start_dpis and nvl(fcbd.end_dpis,txl.in_service_date)
9166: and fbc.book_type_code = txl.corporate_book

Line 9188: fa_category_book_defaults fcbd,

9184: txl.depreciation_id,
9185: txl.kle_id
9186: from okl_txl_Assets_b txl,
9187: fa_book_controls fbc,
9188: fa_category_book_defaults fcbd,
9189: fa_additions fa
9190: where fcbd.category_id = fa.asset_category_id
9191: and fcbd.book_type_code = txl.corporate_book
9192: and fa.asset_number = txl.asset_number

Line 9211: fa_category_book_defaults fcbd

9207: fcbd.prorate_convention_code,
9208: txd.cost
9209: from okl_txd_Assets_b txd,
9210: fa_book_controls fbc,
9211: fa_category_book_defaults fcbd
9212: where fcbd.category_id = p_category_id
9213: and fcbd.book_type_code = txd.tax_book
9214: and p_in_service_date between fcbd.start_dpis and nvl(fcbd.end_dpis,p_in_service_date)
9215: and fbc.book_type_code = txd.tax_book

Line 9234: fa_category_book_defaults fcbd

9230: fcbd.prorate_convention_code,
9231: txd.cost
9232: from okl_txd_Assets_b txd,
9233: fa_book_controls fbc,
9234: fa_category_book_defaults fcbd
9235: where fcbd.category_id = p_category_id
9236: and fcbd.book_type_code = txd.tax_book
9237: and p_in_service_date between fcbd.start_dpis and nvl(fcbd.end_dpis,p_in_service_date)
9238: and fbc.book_type_code = txd.tax_book

Line 9281: from fa_category_book_defaults

9277: life_in_months,
9278: basic_rate,
9279: adjusted_rate,
9280: prorate_convention_code
9281: from fa_category_book_defaults
9282: where book_type_code = p_book
9283: and category_id = p_category_id
9284: and p_date between start_dpis and nvl(end_dpis,p_date);
9285: