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.

[Home] [Help]

APPS.OKL_QUOTE_TO_CONTRACT_PVT dependencies on DUAL

Line 872: FROM DUAL;

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

Line 954: FROM dual;

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

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

3731:
3732: FOR l_eot_typ_rec IN c_get_eot_type(l_lapv_rec.quote_id) LOOP
3733: l_eot_type := l_eot_typ_rec.eot_type_code;
3734: END LOOP;
3735: IF l_eot_type IN ('AMOUNT','RESIDUAL_AMOUNT') THEN
3736: l_klev_fin_rec.residual_value := nvl(l_quote_asset_rec.end_of_term_value,l_quote_asset_rec.end_of_term_value_default);
3737: l_klev_fin_rec.residual_percentage := NULL;
3738: ELSE
3739: l_klev_fin_rec.residual_value := NULL;

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

3732: FOR l_eot_typ_rec IN c_get_eot_type(l_lapv_rec.quote_id) LOOP
3733: l_eot_type := l_eot_typ_rec.eot_type_code;
3734: END LOOP;
3735: IF l_eot_type IN ('AMOUNT','RESIDUAL_AMOUNT') THEN
3736: l_klev_fin_rec.residual_value := nvl(l_quote_asset_rec.end_of_term_value,l_quote_asset_rec.end_of_term_value_default);
3737: l_klev_fin_rec.residual_percentage := NULL;
3738: ELSE
3739: l_klev_fin_rec.residual_value := NULL;
3740: 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 3737: l_klev_fin_rec.residual_percentage := NULL;

3733: l_eot_type := l_eot_typ_rec.eot_type_code;
3734: END LOOP;
3735: IF l_eot_type IN ('AMOUNT','RESIDUAL_AMOUNT') THEN
3736: l_klev_fin_rec.residual_value := nvl(l_quote_asset_rec.end_of_term_value,l_quote_asset_rec.end_of_term_value_default);
3737: l_klev_fin_rec.residual_percentage := NULL;
3738: ELSE
3739: l_klev_fin_rec.residual_value := NULL;
3740: l_klev_fin_rec.residual_percentage := nvl(l_quote_asset_rec.end_of_term_value,l_quote_asset_rec.end_of_term_value_default);
3741: END IF;

Line 3739: l_klev_fin_rec.residual_value := NULL;

3735: IF l_eot_type IN ('AMOUNT','RESIDUAL_AMOUNT') THEN
3736: l_klev_fin_rec.residual_value := nvl(l_quote_asset_rec.end_of_term_value,l_quote_asset_rec.end_of_term_value_default);
3737: l_klev_fin_rec.residual_percentage := NULL;
3738: ELSE
3739: l_klev_fin_rec.residual_value := NULL;
3740: l_klev_fin_rec.residual_percentage := nvl(l_quote_asset_rec.end_of_term_value,l_quote_asset_rec.end_of_term_value_default);
3741: END IF;
3742:
3743: --sechawla 7-dec-09 9120203 : begin

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

3736: l_klev_fin_rec.residual_value := nvl(l_quote_asset_rec.end_of_term_value,l_quote_asset_rec.end_of_term_value_default);
3737: l_klev_fin_rec.residual_percentage := NULL;
3738: ELSE
3739: l_klev_fin_rec.residual_value := NULL;
3740: l_klev_fin_rec.residual_percentage := nvl(l_quote_asset_rec.end_of_term_value,l_quote_asset_rec.end_of_term_value_default);
3741: END IF;
3742:
3743: --sechawla 7-dec-09 9120203 : begin
3744: l_talv_fa_rec.corporate_book := l_corp_book;