APPS.OKL_CS_TRANSFER_ASSUMPTION_PVT dependencies on OKL_TAA_REQUEST_DETAILS_V

Line 550: FROM okl_taa_request_details_v

546: WHERE PARTY_ID = p_party_id;
547:
548: CURSOR c_taa_record(p_tcn_id IN NUMBER) IS
549: SELECT *
550: FROM okl_taa_request_details_v
551: WHERE tcn_id = p_tcn_id;
552:
553: CURSOR c_bill_to(p_site_id IN NUMBER) IS
554: SELECT id1,

Line 828: FROM okl_taa_request_details_v

824: --Obtain the insuance details of the taa request.
825: -- changed tcn_id to id for bug:4094898
826: CURSOR c_taa_record(p_taa_id IN NUMBER) IS
827: SELECT *
828: FROM okl_taa_request_details_v
829: WHERE id = p_taa_id;
830:
831: --Obtain the insurer/insurance_agent name
832: CURSOR c_lessee(p_party_id IN NUMBER) IS