APPS.FII_TIME_API dependencies on DUAL

Line 1169: from dual;

1165: l_as_of_date := trunc(as_of_date);
1166:
1167: select l_as_of_date - 29
1168: into l_date
1169: from dual;
1170:
1171: return l_date;
1172: end;
1173:

Line 1189: from dual;

1185: l_as_of_date := trunc(as_of_date);
1186:
1187: select l_as_of_date - 89
1188: into l_date
1189: from dual;
1190:
1191: return l_date;
1192: end;
1193:

Line 1209: from dual;

1205: l_as_of_date := trunc(as_of_date);
1206:
1207: select l_as_of_date - 364
1208: into l_date
1209: from dual;
1210:
1211: return l_date;
1212: end;
1213:

Line 1229: from dual;

1225: l_as_of_date := trunc(as_of_date);
1226:
1227: select l_as_of_date-6
1228: into l_date
1229: from dual;
1230:
1231: return l_date;
1232: end;
1233:

Line 1253: from dual;

1249: l_as_of_date := trunc(as_of_date);
1250:
1251: select to_char(ent_cqtr_end(l_as_of_date)-l_as_of_date)
1252: into l_day_left
1253: from dual;
1254:
1255: select sequence
1256: into l_qtr
1257: from fii_time_ent_qtr