eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_QUOTE_TO_CONTRACT_PVT dependencies on DUAL

Line 870: FROM DUAL;

866: p_periods NUMBER,
867: p_frequency VARCHAR2) RETURN DATE IS
868: CURSOR find_months_per_period_csr(p_frequency VARCHAR2) IS
869: SELECT DECODE(p_frequency,'M',1,'Q',3,'S',6,'A',12) months_per_period
870: FROM DUAL;
871: l_period_end_date DATE;
872: BEGIN
873: FOR l_months_per_period_csr IN find_months_per_period_csr(p_frequency => p_frequency)
874: LOOP

Line 952: FROM dual;

948: WHERE chr.id = p_chr_id
949: AND chr.id = khr.id;
950: SELECT DECODE(p_payment_frequency, 'A', 12, 'S', 6, 'Q', 3, 'M', 1)
951: INTO l_mpp
952: FROM dual;
953: ----------------------------------------------------------------------------------------------
954: -- Explanation of validations available in file 'SO Error Messages.xls' (see reference number)
955: ----------------------------------------------------------------------------------------------
956: -- 1.

Line 3649: IF l_eot_type IN ('AMOUNT','RESIDUAL_AMOUNT') THEN

3645:
3646: FOR l_eot_typ_rec IN c_get_eot_type(l_lapv_rec.quote_id) LOOP
3647: l_eot_type := l_eot_typ_rec.eot_type_code;
3648: END LOOP;
3649: IF l_eot_type IN ('AMOUNT','RESIDUAL_AMOUNT') THEN
3650: l_klev_fin_rec.residual_value := nvl(l_quote_asset_rec.end_of_term_value,l_quote_asset_rec.end_of_term_value_default);
3651: l_klev_fin_rec.residual_percentage := NULL;
3652: ELSE
3653: l_klev_fin_rec.residual_value := NULL;

Line 3650: l_klev_fin_rec.residual_value := nvl(l_quote_asset_rec.end_of_term_value,l_quote_asset_rec.end_of_term_value_default);

3646: FOR l_eot_typ_rec IN c_get_eot_type(l_lapv_rec.quote_id) LOOP
3647: l_eot_type := l_eot_typ_rec.eot_type_code;
3648: END LOOP;
3649: IF l_eot_type IN ('AMOUNT','RESIDUAL_AMOUNT') THEN
3650: l_klev_fin_rec.residual_value := nvl(l_quote_asset_rec.end_of_term_value,l_quote_asset_rec.end_of_term_value_default);
3651: l_klev_fin_rec.residual_percentage := NULL;
3652: ELSE
3653: l_klev_fin_rec.residual_value := NULL;
3654: l_klev_fin_rec.residual_percentage := nvl(l_quote_asset_rec.end_of_term_value,l_quote_asset_rec.end_of_term_value_default);

Line 3651: l_klev_fin_rec.residual_percentage := NULL;

3647: l_eot_type := l_eot_typ_rec.eot_type_code;
3648: END LOOP;
3649: IF l_eot_type IN ('AMOUNT','RESIDUAL_AMOUNT') THEN
3650: l_klev_fin_rec.residual_value := nvl(l_quote_asset_rec.end_of_term_value,l_quote_asset_rec.end_of_term_value_default);
3651: l_klev_fin_rec.residual_percentage := NULL;
3652: ELSE
3653: l_klev_fin_rec.residual_value := NULL;
3654: l_klev_fin_rec.residual_percentage := nvl(l_quote_asset_rec.end_of_term_value,l_quote_asset_rec.end_of_term_value_default);
3655: END IF;

Line 3653: l_klev_fin_rec.residual_value := NULL;

3649: IF l_eot_type IN ('AMOUNT','RESIDUAL_AMOUNT') THEN
3650: l_klev_fin_rec.residual_value := nvl(l_quote_asset_rec.end_of_term_value,l_quote_asset_rec.end_of_term_value_default);
3651: l_klev_fin_rec.residual_percentage := NULL;
3652: ELSE
3653: l_klev_fin_rec.residual_value := NULL;
3654: l_klev_fin_rec.residual_percentage := nvl(l_quote_asset_rec.end_of_term_value,l_quote_asset_rec.end_of_term_value_default);
3655: END IF;
3656:
3657: l_talv_fa_rec.dnz_khr_id := l_clev_fin_rec.dnz_chr_id;

Line 3654: l_klev_fin_rec.residual_percentage := nvl(l_quote_asset_rec.end_of_term_value,l_quote_asset_rec.end_of_term_value_default);

3650: l_klev_fin_rec.residual_value := nvl(l_quote_asset_rec.end_of_term_value,l_quote_asset_rec.end_of_term_value_default);
3651: l_klev_fin_rec.residual_percentage := NULL;
3652: ELSE
3653: l_klev_fin_rec.residual_value := NULL;
3654: l_klev_fin_rec.residual_percentage := nvl(l_quote_asset_rec.end_of_term_value,l_quote_asset_rec.end_of_term_value_default);
3655: END IF;
3656:
3657: l_talv_fa_rec.dnz_khr_id := l_clev_fin_rec.dnz_chr_id;
3658: l_talv_fa_rec.asset_number := l_quote_asset_rec.ASSET_NUMBER;