APPS.OKC_CLE_PVT dependencies on DUAL

Line 5130: FROM (SELECT trunc(MONTHS_BETWEEN(l_cle_rec.end_date, l_cle_rec.start_date)/12) nyears FROM dual) dual

5126: DECODE(ADD_MONTHS(l_cle_rec.end_date, -12),( l_cle_rec.end_date-366), 0,
5127: DECODE(ADD_MONTHS(l_cle_rec.start_date, (nyears+1)*12) -
5128: ADD_MONTHS(l_cle_rec.start_date, nyears*12), 366, 1, 0)))
5129: / (nyears+1) /(l_cle_rec.end_date-l_cle_rec.start_date+1)
5130: FROM (SELECT trunc(MONTHS_BETWEEN(l_cle_rec.end_date, l_cle_rec.start_date)/12) nyears FROM dual) dual
5131: WHERE l_cle_rec.lse_id in (1,12,14,19,46,7,8,9,10,11,13,18,25,35)),0),
5132: /*** R12 Data Model Changes Start **/
5133: l_cle_rec.date_cancelled ,
5134: --l_cle_rec.canc_reason_code ,

Line 6405: FROM (SELECT trunc(MONTHS_BETWEEN(x_cle_rec.end_date, x_cle_rec.start_date)/12) nyears FROM dual) dual ;

6401: DECODE(ADD_MONTHS(x_cle_rec.end_date, -12),( x_cle_rec.end_date-366), 0,
6402: DECODE(ADD_MONTHS(x_cle_rec.start_date, (nyears+1)*12) - ADD_MONTHS(x_cle_rec.start_date, nyears*12), 366, 1, 0)))
6403: / (nyears+1) /(x_cle_rec.end_date-x_cle_rec.start_date+1)
6404: INTO x_cle_rec.annualized_factor
6405: FROM (SELECT trunc(MONTHS_BETWEEN(x_cle_rec.end_date, x_cle_rec.start_date)/12) nyears FROM dual) dual ;
6406:
6407: EXCEPTION
6408:
6409: WHEN NO_DATA_FOUND THEN