DBA Data[Home] [Help]

APPS.OKS_SETUP_UTIL_PUB dependencies on DUAL

Line 5414: FROM (SELECT trunc(MONTHS_BETWEEN(v_end_date, v_start_date)/12) nyears FROM dual) dual ;

5410: SELECT (ADD_MONTHS(v_start_date, (nyears+1)*12) - v_start_date -
5411: DECODE(ADD_MONTHS(v_end_date, -12),( v_end_date-366), 0,
5412: DECODE(ADD_MONTHS(v_start_date, (nyears+1)*12) - ADD_MONTHS(v_start_date, nyears*12), 366, 1, 0)))
5413: / (nyears+1) /(v_end_date-v_start_date+1)
5414: FROM (SELECT trunc(MONTHS_BETWEEN(v_end_date, v_start_date)/12) nyears FROM dual) dual ;
5415:
5416: BEGIN
5417:
5418: IF p_lse_id in (1,12,14,19,46,7,8,9,10,11,13,18,25,35) THEN