APPS.OKL_LEASE_QUOTE_PVT dependencies on OKL_INSURANCE_ESTIMATES_B

Line 813: FROM OKL_INSURANCE_ESTIMATES_B

809: AND PARENT_OBJECT_CODE = 'LEASEQUOTE';
810:
811: CURSOR c_get_ins_estimates IS
812: SELECT id
813: FROM OKL_INSURANCE_ESTIMATES_B
814: WHERE LEASE_QUOTE_ID = p_quote_id;
815:
816: BEGIN
817:

Line 1772: FROM OKL_INSURANCE_ESTIMATES_B

1768:
1769: --Added by jjuneja
1770: CURSOR c_get_insurance_estimate IS
1771: SELECT id
1772: FROM OKL_INSURANCE_ESTIMATES_B
1773: WHERE lease_quote_id = p_source_quote_id ;
1774: --End of addtion by jjuneja
1775: BEGIN
1776:

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

2298: DELETE FROM okl_services_b WHERE parent_object_code = 'LEASEQUOTE' AND parent_object_id = p_lease_qte_rec.id;
2299:
2300: -- QUE
2301: DELETE FROM okl_insurance_estimates_tl WHERE id IN
2302: (SELECT id FROM okl_insurance_estimates_b WHERE lease_quote_id = p_lease_qte_rec.id);
2303: DELETE FROM okl_insurance_estimates_b WHERE lease_quote_id = p_lease_qte_rec.id;
2304:
2305: x_return_status := G_RET_STS_SUCCESS;
2306:

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

2299:
2300: -- QUE
2301: DELETE FROM okl_insurance_estimates_tl WHERE id IN
2302: (SELECT id FROM okl_insurance_estimates_b WHERE lease_quote_id = p_lease_qte_rec.id);
2303: DELETE FROM okl_insurance_estimates_b WHERE lease_quote_id = p_lease_qte_rec.id;
2304:
2305: x_return_status := G_RET_STS_SUCCESS;
2306:
2307: EXCEPTION