APPS.OKL_AM_CALC_QUOTE_PYMNT_PVT dependencies on DUAL

Line 1509: --FROM DUAL;

1505:
1506: -- Get the start date of the last period
1507: CURSOR l_lastperiodstatdt_csr(cp_firstperiodstartdt IN DATE, cp_number_of_months IN NUMBER) IS
1508: --SELECT add_months(cp_firstperiodstartdt,cp_number_of_months)
1509: --FROM DUAL;
1510: -- vsgandhi bug 14838755 :03-dec-2012
1511: SELECT okl_lla_util_pvt.calculate_end_date
1512: (cp_firstperiodstartdt,
1513: cp_number_of_months,

Line 1515: FROM dual;

1511: SELECT okl_lla_util_pvt.calculate_end_date
1512: (cp_firstperiodstartdt,
1513: cp_number_of_months,
1514: to_char(cp_firstperiodstartdt, 'DD') ) +1
1515: FROM dual;
1516:
1517:
1518: -- Get the number of months between period start dt and quote eff date
1519: CURSOR l_monthsuptodate_csr(cp_quote_eff_dt IN DATE, cp_period_start_dt IN DATE) IS

Line 1521: FROM DUAL;

1517:
1518: -- Get the number of months between period start dt and quote eff date
1519: CURSOR l_monthsuptodate_csr(cp_quote_eff_dt IN DATE, cp_period_start_dt IN DATE) IS
1520: SELECT months_between(cp_quote_eff_dt,cp_period_start_dt)
1521: FROM DUAL;
1522:
1523: /*-----------------------------------------------------------------------+
1524: | SubType Declarations
1525: +-----------------------------------------------------------------------*/