[Home] [Help]
14920: CLOSE c_get_primary_quote;
14921: END IF;
14922:
14923: IF (ln_quote_id IS NOT NULL) THEN
14924: ln_leaseapp_financed_amount := okl_lease_app_pvt.get_financed_amount(p_lease_qte_id => ln_quote_id);
14925: END IF;
14926:
14927: IF (ln_contract_financed_amount IS NOT NULL AND ln_leaseapp_financed_amount IS NOT NULL) THEN
14928: IF ln_contract_financed_amount <= ln_leaseapp_financed_amount THEN
14991: CLOSE c_get_primary_quote;
14992: END IF;
14993:
14994: IF (ln_quote_id IS NOT NULL) THEN
14995: ln_leaseapp_financed_amount := okl_lease_app_pvt.get_financed_amount(p_lease_qte_id => ln_quote_id);
14996: END IF;
14997:
14998: IF (ln_contract_funded_amount IS NOT NULL AND ln_leaseapp_financed_amount IS NOT NULL) THEN
14999: IF ln_contract_funded_amount <= ln_leaseapp_financed_amount THEN
15149: OPEN c_k_booking_date;
15150: FETCH c_k_booking_date INTO ld_k_booking_date;
15151: CLOSE c_k_booking_date;
15152:
15153: ld_lap_app_exp_date := okl_lease_app_pvt.get_approval_exp_date(p_lease_app_id => ln_lease_app_id);
15154:
15155: IF (ld_k_booking_date IS NULL) THEN
15156: ld_k_booking_date := SYSDATE;
15157: END IF;
15202: OPEN c_k_funding_date;
15203: FETCH c_k_funding_date INTO ld_k_funded_date;
15204: CLOSE c_k_funding_date;
15205:
15206: ld_lap_app_exp_date := okl_lease_app_pvt.get_approval_exp_date(p_lease_app_id => ln_lease_app_id);
15207:
15208: IF (ld_lap_app_exp_date IS NOT NULL) THEN
15209: IF (ld_k_funded_date <= ld_lap_app_exp_date ) THEN
15210: RETURN 'P';