APPS.OKL_LEASE_QUOTE_PVT dependencies on OKL_LEASE_APPLICATIONS_B

Line 336: FROM okl_lease_applications_b

332: WHERE id = p_lease_qte_rec.parent_object_id;
333:
334: CURSOR chk_parent_dates_leaseapp IS
335: SELECT TRUNC(valid_from)
336: FROM okl_lease_applications_b
337: WHERE id = p_lease_qte_rec.parent_object_id;
338:
339: l_refno_unq_chk NUMBER;
340: l_parent_valid_from DATE;

Line 1082: lv_leaseapp_status okl_lease_applications_b.application_status%TYPE;

1078:
1079: lb_handle_subpool BOOLEAN := FALSE;
1080: lb_validate BOOLEAN := TRUE;
1081: lv_status okl_lease_quotes_b.status%TYPE;
1082: lv_leaseapp_status okl_lease_applications_b.application_status%TYPE;
1083: ln_parent_object_id okl_lease_quotes_b.parent_object_id%TYPE;
1084:
1085: --gboomina Bug 7033915 start
1086: CURSOR lease_qte_credit_app_csr (p_lap_id OKL_LEASE_QUOTES_B.parent_object_id%TYPE) IS

Line 1250: FROM okl_lease_applications_b

1246: l_lease_qte_rec.status <> 'CT-ACCEPTED') THEN
1247:
1248: SELECT application_status
1249: INTO lv_leaseapp_status
1250: FROM okl_lease_applications_b
1251: where id = ln_parent_object_id;
1252:
1253: IF (lv_leaseapp_status IN ('PR-COMPLETE', 'PR-APPROVED')) THEN
1254: OKL_LEASE_APP_PVT.set_lease_app_status(p_api_version => G_API_VERSION,