APPS.OKL_LEASE_QUOTE_PVT dependencies on OKL_INSURANCE_ESTIMATES_B

Line 803: FROM OKL_INSURANCE_ESTIMATES_B

799: AND PARENT_OBJECT_CODE = 'LEASEQUOTE';
800:
801: CURSOR c_get_ins_estimates IS
802: SELECT id
803: FROM OKL_INSURANCE_ESTIMATES_B
804: WHERE LEASE_QUOTE_ID = p_quote_id;
805:
806: BEGIN
807:

Line 2246: (SELECT id FROM okl_insurance_estimates_b WHERE lease_quote_id = p_lease_qte_rec.id);

2242: DELETE FROM okl_services_b WHERE parent_object_code = 'LEASEQUOTE' AND parent_object_id = p_lease_qte_rec.id;
2243:
2244: -- QUE
2245: DELETE FROM okl_insurance_estimates_tl WHERE id IN
2246: (SELECT id FROM okl_insurance_estimates_b WHERE lease_quote_id = p_lease_qte_rec.id);
2247: DELETE FROM okl_insurance_estimates_b WHERE lease_quote_id = p_lease_qte_rec.id;
2248:
2249: x_return_status := G_RET_STS_SUCCESS;
2250:

Line 2247: DELETE FROM okl_insurance_estimates_b WHERE lease_quote_id = p_lease_qte_rec.id;

2243:
2244: -- QUE
2245: DELETE FROM okl_insurance_estimates_tl WHERE id IN
2246: (SELECT id FROM okl_insurance_estimates_b WHERE lease_quote_id = p_lease_qte_rec.id);
2247: DELETE FROM okl_insurance_estimates_b WHERE lease_quote_id = p_lease_qte_rec.id;
2248:
2249: x_return_status := G_RET_STS_SUCCESS;
2250:
2251: EXCEPTION