APPS.OKL_LEASE_QUOTE_PVT dependencies on OKL_SERVICES_B

Line 797: FROM OKL_SERVICES_B

793: AND PARENT_OBJECT_CODE = 'LEASEQUOTE';
794:
795: CURSOR c_get_services IS
796: SELECT id
797: FROM OKL_SERVICES_B
798: WHERE PARENT_OBJECT_ID = p_quote_id
799: AND PARENT_OBJECT_CODE = 'LEASEQUOTE';
800:
801: CURSOR c_get_ins_estimates IS

Line 1729: FROM OKL_SERVICES_B

1725: x_fee_id NUMBER;
1726:
1727: CURSOR c_get_services IS
1728: SELECT id
1729: FROM OKL_SERVICES_B
1730: WHERE PARENT_OBJECT_ID = p_source_quote_id
1731: AND PARENT_OBJECT_CODE = 'LEASEQUOTE';
1732:
1733: CURSOR c_get_nonconfig_fees IS

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

2237: DELETE FROM okl_fees_b WHERE parent_object_code = 'LEASEQUOTE' AND parent_object_id = p_lease_qte_rec.id;
2238:
2239: -- SVC
2240: DELETE FROM okl_services_tl WHERE id IN
2241: (SELECT id FROM okl_services_b WHERE parent_object_code = 'LEASEQUOTE' AND parent_object_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

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

2238:
2239: -- SVC
2240: DELETE FROM okl_services_tl WHERE id IN
2241: (SELECT id FROM okl_services_b WHERE parent_object_code = 'LEASEQUOTE' AND parent_object_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);