APPS.OKL_DEAL_ASSET_PVT dependencies on FA_ADDITIONS_B

Line 67: l_asset_number FA_ADDITIONS_B.ASSET_NUMBER%TYPE;

63: l_itiv_ib_tbl OKL_ITI_PVT.itiv_tbl_type;
64: -- gboomina Added for Bug 5876083 - Start
65: l_tal_id OKL_TXL_ASSETS_B.ID%TYPE;
66: l_clev_fa_id OKC_K_LINES_B.ID%TYPE;
67: l_asset_number FA_ADDITIONS_B.ASSET_NUMBER%TYPE;
68: -- gboomina Added for Bug 5876083 - End
69: x_clev_fin_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
70: x_clev_model_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;
71: x_clev_fa_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;

Line 857: CURSOR c_asset_key_active(p_asset_number IN fa_additions_b.asset_number%type)

853:
854: --Bug# 8652738
855: -- Corrected table name to fa_additions
856: -- This cursor is used to get Asset Key from FA tables for Active Contract
857: CURSOR c_asset_key_active(p_asset_number IN fa_additions_b.asset_number%type)
858: IS
859: select faa.asset_key_ccid ccid,
860: fakw.concatenated_segments segs
861: from fa_additions faa,

Line 869: CURSOR c_fa_line_active(p_asset_number IN fa_additions_b.asset_number%type)

865: l_asset_key_active_rec c_asset_key_active%ROWTYPE;
866:
867: -- This cursor is used to get Model Number, Manufacturer and FA Location
868: -- from FA tables for Active Contract
869: CURSOR c_fa_line_active(p_asset_number IN fa_additions_b.asset_number%type)
870: IS
871: select loc.name fa_location_name,
872: loc.id1 fa_location_id,
873: fa.manufacturer_name,

Line 877: fa_additions_b fa

873: fa.manufacturer_name,
874: fa.model_number
875: from fa_distribution_history fa_hist,
876: okx_ast_locs_v loc,
877: fa_additions_b fa
878: where fa.asset_id = fa_hist.asset_id
879: and fa_hist.location_id = loc.location_id
880: and fa.asset_number = p_asset_number
881: and fa_hist.transaction_header_id_out is null