APPS.OKL_CS_TRANSFER_ASSUMPTION_PVT dependencies on OKL_TAA_REQUEST_DETAILS_V

Line 507: FROM okl_taa_request_details_v

503: WHERE PARTY_ID = p_party_id;
504:
505: CURSOR c_taa_record(p_tcn_id IN NUMBER) IS
506: SELECT *
507: FROM okl_taa_request_details_v
508: WHERE tcn_id = p_tcn_id;
509:
510: CURSOR c_bill_to(p_site_id IN NUMBER) IS
511: SELECT id1,

Line 782: FROM okl_taa_request_details_v

778: --Obtain the insuance details of the taa request.
779: -- changed tcn_id to id for bug:4094898
780: CURSOR c_taa_record(p_taa_id IN NUMBER) IS
781: SELECT *
782: FROM okl_taa_request_details_v
783: WHERE id = p_taa_id;
784:
785: --Obtain the insurer/insurance_agent name
786: CURSOR c_lessee(p_party_id IN NUMBER) IS