DBA Data[Home] [Help]

APPS.BIX_SESSION_LOAD_PKG dependencies on FII_TIME_DAY

Line 1249: fii_time_day ftd

1245: sum(bes.available_time) available_time,
1246: sum(bes.idle_time) idle_time,
1247: sum(bes.agent_cost) agent_cost
1248: FROM BIX_AGENT_SESSION_F bes,
1249: fii_time_day ftd
1250: WHERE bes.time_id = ftd.report_date_julian
1251: AND bes.period_type_id = 1
1252: GROUP BY
1253: bes.agent_id,

Line 1302: FROM fii_time_day

1298: p_has_missing_date := FALSE;
1299:
1300: SELECT count(*)
1301: INTO l_count1
1302: FROM fii_time_day
1303: WHERE report_date between trunc(p_start_date) and trunc(p_end_date);
1304:
1305: SELECT (trunc(p_end_date) - trunc(p_start_date)) + 1
1306: INTO l_count2