DBA Data[Home] [Help]

APPS.OKL_AM_CALC_QUOTE_PYMNT_PVT dependencies on DUAL

Line 1508: FROM DUAL;

1504:
1505: -- Get the start date of the last period
1506: CURSOR l_lastperiodstatdt_csr(cp_firstperiodstartdt IN DATE, cp_number_of_months IN NUMBER) IS
1507: SELECT add_months(cp_firstperiodstartdt,cp_number_of_months)
1508: FROM DUAL;
1509:
1510: -- Get the number of months between period start dt and quote eff date
1511: CURSOR l_monthsuptodate_csr(cp_quote_eff_dt IN DATE, cp_period_start_dt IN DATE) IS
1512: SELECT months_between(cp_quote_eff_dt,cp_period_start_dt)

Line 1513: FROM DUAL;

1509:
1510: -- Get the number of months between period start dt and quote eff date
1511: CURSOR l_monthsuptodate_csr(cp_quote_eff_dt IN DATE, cp_period_start_dt IN DATE) IS
1512: SELECT months_between(cp_quote_eff_dt,cp_period_start_dt)
1513: FROM DUAL;
1514:
1515: /*-----------------------------------------------------------------------+
1516: | SubType Declarations
1517: +-----------------------------------------------------------------------*/