APPS.FII_SIZING_UTIL dependencies on DUAL

Line 492: from dual

488: and per.period_set_name = book.period_set_name
489: and per.period_type = book.accounted_period_type)
490: union all
491: select to_date('31-12-2000','dd-mm-yyyy')-to_date('01-01-1995','dd-mm-yyyy')+1 cnt
492: from dual
493: union all
494: select months_between(last_day(to_date('31-12-2000','dd-mm-yyyy')),last_day(to_date('01-01-1995','dd-mm-yyyy')))+1 cnt
495: from dual);
496: BEGIN

Line 495: from dual);

491: select to_date('31-12-2000','dd-mm-yyyy')-to_date('01-01-1995','dd-mm-yyyy')+1 cnt
492: from dual
493: union all
494: select months_between(last_day(to_date('31-12-2000','dd-mm-yyyy')),last_day(to_date('01-01-1995','dd-mm-yyyy')))+1 cnt
495: from dual);
496: BEGIN
497: OPEN c_cnt_rows;
498: FETCH c_cnt_rows INTO p_num_rows;
499: CLOSE c_cnt_rows;