APPS.OKL_CS_TRANSFER_ASSUMPTION_PVT dependencies on OKL_TAA_REQUEST_DETAILS_B

Line 593: FROM okl_taa_request_details_b

589:
590: -- populating the new contract number
591: CURSOR c_new_ctr_no(p_request_id IN NUMBER) IS
592: SELECT new_contract_number
593: FROM okl_taa_request_details_b
594: WHERE tcn_id = p_request_id;
595:
596: -- populating the master lease agreement and credit line no
597: CURSOR c_mla_no(p_contract_id IN NUMBER) IS

Line 641: l_taa_record OKL_TAA_REQUEST_DETAILS_B%rowtype;

637: l_contact_name VARCHAR2(300);
638: l_contact_party_id NUMBER;
639: l_phone VARCHAR2(30);
640: l_request_record OKL_TRX_CONTRACTS%ROWTYPE;
641: l_taa_record OKL_TAA_REQUEST_DETAILS_B%rowtype;
642: l_ctr_no VARCHAR2(120);
643: l_acct_no VARCHAR2(30);
644: l_acct_id NUMBER;
645: l_location VARCHAR2(4000);

Line 844: l_taa_record OKL_TAA_REQUEST_DETAILS_B%rowtype;

840: l_api_version CONSTANT NUMBER := 1;
841:
842: l_insurer VARCHAR2(360);
843: l_insurance_agent VARCHAR2(360);
844: l_taa_record OKL_TAA_REQUEST_DETAILS_B%rowtype;
845:
846: BEGIN
847: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
848: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'OKL_CS_TRANSFER_ASSUMPTION_PVT.Populate_New_Lessee_details','Begin(+)');