APPS.OKL_LEASE_QUOTE_ASSET_PVT dependencies on DUAL

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

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

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

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

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

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

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

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

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

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