APPS.ENG_PARAMETER_ENGCYCLE dependencies on DUAL

Line 121: from dual;

117: BEGIN
118: select to_date( P_FROM_DATE, DATE_FORMAT ),
119: to_date( P_TO_DATE, DATE_FORMAT )
120: into newfromdate, newtodate
121: from dual;
122:
123: IF (newfromdate is null)
124: OR (newtodate is null)
125: OR (newfromdate > newtodate) THEN

Line 251: FROM dual;

247: BEGIN
248: SELECT to_char(add_months(sysdate, -12), DATE_FORMAT),
249: to_char(sysdate, DATE_FORMAT)
250: INTO from_date, to_date
251: FROM dual;
252:
253: param(i).Label := FND_MESSAGE.get_string( 'PER', 'HR_BIS_REPORTING_DATE');
254: param(i).Value := htf.formText('p_from_date', NULL, NULL, from_date);
255: param(i).Value := param(i).Value || ' - ' ||