APPS.OKL_AM_REPURCHASE_ASSET_PVT dependencies on OKC_K_LINES_B

Line 647: FROM okc_k_lines_b

643: ) IS
644: -- select the contract id for the contract line id
645: CURSOR l_clev_csr (p_kle_id NUMBER) IS
646: SELECT chr_id
647: FROM okc_k_lines_b
648: WHERE ID = p_kle_id;
649:
650: -- see if any quotes already exist for this asset return id
651: CURSOR l_qtev_csr (p_art_id NUMBER) IS

Line 686: FROM okc_k_lines_b

682:
683: -- SECHAWLA 22-JAN-03 Bug # 2762419 : Added this cursor to check the status of the asset line
684: CURSOR l_okclines_csr (p_kle_id IN NUMBER) IS
685: SELECT sts_code
686: FROM okc_k_lines_b
687: WHERE ID = p_kle_id;
688:
689: l_contract_number VARCHAR2 (120);
690: l_contract_mismatch BOOLEAN := FALSE;

Line 703: l_sts_code okc_k_lines_b.sts_code%TYPE;

699: l_control_flag_update VARCHAR2 (200) := 'REPUR_QUOTE_UPDATE';
700: l_taiv_rec taiv_rec_type;
701: db_accepted_yn VARCHAR2 (1);
702: -- SECHAWLA 22-JAN-03 Bug # 2762419 : New declarations
703: l_sts_code okc_k_lines_b.sts_code%TYPE;
704: l_asset_number okl_am_asset_returns_uv.asset_number%TYPE;
705: -- RRAVIKIR Legal Entity Changes
706: l_legal_entity_id NUMBER;
707: -- Legal Entity Changes End