APPS.OKL_LEASE_QUOTE_PVT dependencies on OKL_SERVICES_B

Line 807: FROM OKL_SERVICES_B

803: AND PARENT_OBJECT_CODE = 'LEASEQUOTE';
804:
805: CURSOR c_get_services IS
806: SELECT id
807: FROM OKL_SERVICES_B
808: WHERE PARENT_OBJECT_ID = p_quote_id
809: AND PARENT_OBJECT_CODE = 'LEASEQUOTE';
810:
811: CURSOR c_get_ins_estimates IS

Line 1758: FROM OKL_SERVICES_B

1754: --End of addition by jjuneja
1755:
1756: CURSOR c_get_services IS
1757: SELECT id
1758: FROM OKL_SERVICES_B
1759: WHERE PARENT_OBJECT_ID = p_source_quote_id
1760: AND PARENT_OBJECT_CODE = 'LEASEQUOTE';
1761:
1762: CURSOR c_get_nonconfig_fees IS

Line 2297: (SELECT id FROM okl_services_b WHERE parent_object_code = 'LEASEQUOTE' AND parent_object_id = p_lease_qte_rec.id);

2293: DELETE FROM okl_fees_b WHERE parent_object_code = 'LEASEQUOTE' AND parent_object_id = p_lease_qte_rec.id;
2294:
2295: -- SVC
2296: DELETE FROM okl_services_tl WHERE id IN
2297: (SELECT id FROM okl_services_b WHERE parent_object_code = 'LEASEQUOTE' AND parent_object_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

Line 2298: DELETE FROM okl_services_b WHERE parent_object_code = 'LEASEQUOTE' AND parent_object_id = p_lease_qte_rec.id;

2294:
2295: -- SVC
2296: DELETE FROM okl_services_tl WHERE id IN
2297: (SELECT id FROM okl_services_b WHERE parent_object_code = 'LEASEQUOTE' AND parent_object_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);