APPS.OKL_LEASE_QUOTE_ASSET_PVT dependencies on DUAL

Line 1111: IF (lv_eot_type_code IN ('PERCENT', 'RESIDUAL_PERCENT')) THEN

1107: END IF;
1108: END LOOP;
1109:
1110: -- Calculate the EOT value
1111: IF (lv_eot_type_code IN ('PERCENT', 'RESIDUAL_PERCENT')) THEN
1112: ln_eot_default_value := l_asset_rec.end_of_term_value_default;
1113: ELSIF (lv_eot_type_code IN ('AMOUNT', 'RESIDUAL_AMOUNT')) THEN
1114: IF (l_asset_rec.end_of_term_value_default IS NOT NULL) THEN
1115: ln_eot_default_value := l_asset_rec.end_of_term_value_default * ln_number_of_units;

Line 1113: ELSIF (lv_eot_type_code IN ('AMOUNT', 'RESIDUAL_AMOUNT')) THEN

1109:
1110: -- Calculate the EOT value
1111: IF (lv_eot_type_code IN ('PERCENT', 'RESIDUAL_PERCENT')) THEN
1112: ln_eot_default_value := l_asset_rec.end_of_term_value_default;
1113: ELSIF (lv_eot_type_code IN ('AMOUNT', 'RESIDUAL_AMOUNT')) THEN
1114: IF (l_asset_rec.end_of_term_value_default IS NOT NULL) THEN
1115: ln_eot_default_value := l_asset_rec.end_of_term_value_default * ln_number_of_units;
1116: END IF;
1117: END IF;

Line 3449: SELECT okl_qua_ref_seq.nextval INTO l_asset_rec.asset_number FROM DUAL;

3445: END IF;
3446: -- End
3447:
3448: -- Generate the Asset number from the sequence
3449: SELECT okl_qua_ref_seq.nextval INTO l_asset_rec.asset_number FROM DUAL;
3450: l_asset_rec.parent_object_id := p_target_quote_id;
3451: l_asset_rec.orig_asset_id := p_source_asset_id;
3452:
3453: -- If product or start date changed for target quote, do not default the

Line 3634: SELECT okl_qua_ref_seq.nextval INTO l_asset_rec.asset_number FROM DUAL;

3630: l_cf_hdr_rec := p_cf_hdr_rec;
3631: l_cashflow_level_tbl := p_cf_level_tbl;
3632:
3633: -- Generate the Asset number from the sequence
3634: SELECT okl_qua_ref_seq.nextval INTO l_asset_rec.asset_number FROM DUAL;
3635:
3636: set_defaults ( p_asset_rec => l_asset_rec
3637: ,p_component_tbl => l_asset_comp_tbl
3638: ,x_return_status => l_return_status );

Line 3861: SELECT okl_qua_ref_seq.nextval INTO l_asset_rec.asset_number FROM DUAL;

3857: l_cf_hdr_rec := p_cf_hdr_rec;
3858: l_cashflow_level_tbl := p_cf_level_tbl;
3859:
3860: -- Generate the Asset number from the sequence
3861: SELECT okl_qua_ref_seq.nextval INTO l_asset_rec.asset_number FROM DUAL;
3862:
3863: set_defaults (p_asset_rec => l_asset_rec
3864: ,p_component_tbl => l_asset_comp_tbl
3865: ,x_return_status => l_return_status );