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 1092: lv_leaseapp_status okl_lease_applications_b.application_status%TYPE;

1088:
1089: lb_handle_subpool BOOLEAN := FALSE;
1090: lb_validate BOOLEAN := TRUE;
1091: lv_status okl_lease_quotes_b.status%TYPE;
1092: lv_leaseapp_status okl_lease_applications_b.application_status%TYPE;
1093: ln_parent_object_id okl_lease_quotes_b.parent_object_id%TYPE;
1094:
1095: --gboomina Bug 7033915 start
1096: CURSOR lease_qte_credit_app_csr (p_lap_id OKL_LEASE_QUOTES_B.parent_object_id%TYPE) IS

Line 1106: FROM OKL_LEASE_APPLICATIONS_B

1102:
1103: CURSOR lap_status_csr(cp_lap_id NUMBER)
1104: IS
1105: SELECT APPLICATION_STATUS LAP_STATUS
1106: FROM OKL_LEASE_APPLICATIONS_B
1107: WHERE ID = cp_lap_id;
1108: l_lap_status OKL_LEASE_APPLICATIONS_B.application_status%type;
1109:
1110: l_primary_quote VARCHAR2(1) := 'N';

Line 1108: l_lap_status OKL_LEASE_APPLICATIONS_B.application_status%type;

1104: IS
1105: SELECT APPLICATION_STATUS LAP_STATUS
1106: FROM OKL_LEASE_APPLICATIONS_B
1107: WHERE ID = cp_lap_id;
1108: l_lap_status OKL_LEASE_APPLICATIONS_B.application_status%type;
1109:
1110: l_primary_quote VARCHAR2(1) := 'N';
1111: l_ct_declined_exist VARCHAR2(1) := 'N';
1112: --gboomina Bug 7033915 end

Line 1276: FROM okl_lease_applications_b

1272: l_lease_qte_rec.status <> 'CT-ACCEPTED') THEN
1273:
1274: SELECT application_status
1275: INTO lv_leaseapp_status
1276: FROM okl_lease_applications_b
1277: where id = ln_parent_object_id;
1278:
1279: IF (lv_leaseapp_status IN ('PR-COMPLETE', 'PR-APPROVED')) THEN
1280: OKL_LEASE_APP_PVT.set_lease_app_status(p_api_version => G_API_VERSION,