3609: END IF;
3610:
3611: IF l_start_date IS NULL THEN
3612: -- Get the System Date in Client Timezone
3613: l_start_date := csf_timezones_pvt.date_to_client_tz_date(SYSDATE);
3614: -- Convert the time to System Timezone
3615: l_start_date := csf_timezones_pvt.date_to_server_tz_date(TRUNC(l_start_date));
3616: END IF;
3617:
3611: IF l_start_date IS NULL THEN
3612: -- Get the System Date in Client Timezone
3613: l_start_date := csf_timezones_pvt.date_to_client_tz_date(SYSDATE);
3614: -- Convert the time to System Timezone
3615: l_start_date := csf_timezones_pvt.date_to_server_tz_date(TRUNC(l_start_date));
3616: END IF;
3617:
3618: IF p_num_days IS NULL OR p_num_days <= 0 THEN
3619: l_num_days := CSR_SCHEDULER_PUB.GET_SCH_PARAMETER_VALUE('spPlanScope');