APPS.OZF_TIME_API_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 19

      SELECT start_date INTO l_start_date
      FROM ozf_time_day
      WHERE report_date_julian=p_time_id;

Line: 25

      SELECT start_date INTO l_start_date
      FROM ozf_time_week
      WHERE week_id=p_time_id;

Line: 31

      SELECT start_date INTO l_start_date
      FROM ozf_time_ent_period
      WHERE ent_period_id=p_time_id;

Line: 37

      SELECT start_date INTO l_start_date
      FROM ozf_time_ent_qtr
      WHERE ent_qtr_id=p_time_id;

Line: 43

      SELECT start_date INTO l_start_date
      FROM ozf_time_ent_year
      WHERE ent_year_id=p_time_id;

Line: 66

      SELECT end_date INTO l_end_date
      FROM ozf_time_day
      WHERE report_date_julian=p_time_id;

Line: 72

      SELECT end_date INTO l_end_date
      FROM ozf_time_week
      WHERE week_id=p_time_id;

Line: 78

      SELECT end_date INTO l_end_date
      FROM ozf_time_ent_period
      WHERE ent_period_id=p_time_id;

Line: 84

      SELECT end_date INTO l_end_date
      FROM ozf_time_ent_qtr
      WHERE ent_qtr_id=p_time_id;

Line: 90

      SELECT end_date INTO l_end_date
      FROM ozf_time_ent_year
      WHERE ent_year_id=p_time_id;

Line: 114

      SELECT TO_CHAR(report_date) INTO l_name
      FROM ozf_time_day
      WHERE report_date_julian=p_time_id;

Line: 120

      SELECT name INTO l_name
      FROM ozf_time_week
      WHERE week_id=p_time_id;

Line: 126

      SELECT name INTO l_name
      FROM ozf_time_ent_period
      WHERE ent_period_id=p_time_id;

Line: 132

      SELECT name INTO l_name
      FROM ozf_time_ent_qtr
      WHERE ent_qtr_id=p_time_id;

Line: 138

      SELECT name INTO l_name
      FROM ozf_time_ent_year
      WHERE ent_year_id=p_time_id;

Line: 164

      SELECT name INTO l_name
      FROM ozf_time_ent_period
      WHERE ent_period_id=l_time_id;

Line: 170

      SELECT name INTO l_name
      FROM ozf_time_ent_qtr
      WHERE ent_qtr_id=l_time_id;

Line: 176

      SELECT name INTO l_name
      FROM ozf_time_ent_year
      WHERE ent_year_id=l_time_id;

Line: 203

      SELECT sequence, ent_year_id INTO l_curr_period, l_curr_year
      FROM ozf_time_ent_period
      WHERE ent_period_id=p_time_id;

Line: 207

      SELECT ent_period_id INTO l_time_id
      FROM ozf_time_ent_period
      WHERE sequence=l_curr_period
        AND ent_year_id=l_curr_year-1;

Line: 214

      SELECT sequence, ent_year_id INTO l_curr_qtr, l_curr_year
      FROM ozf_time_ent_qtr
      WHERE ent_qtr_id=p_time_id;

Line: 218

      SELECT ent_qtr_id INTO l_time_id
      FROM ozf_time_ent_qtr
      WHERE sequence=l_curr_qtr
        AND ent_year_id=l_curr_year-1;

Line: 247

SELECT
ent_year_id
FROM ozf_time_ent_year
WHERE start_date >= l_start_date
AND end_date <= l_end_date;

Line: 255

SELECT
ent_qtr_id
FROM ozf_time_ent_qtr
WHERE start_date >= l_start_date
AND end_date <= l_end_date;

Line: 263

SELECT
ent_period_id
FROM ozf_time_ent_period
WHERE start_date >= l_start_date
AND end_date <= l_end_date;

Line: 271

SELECT
week_id
FROM ozf_time_week
WHERE start_date >= l_start_date
AND end_date <= l_end_date;

Line: 345

 SELECT 'Y'
   FROM DUAL
 WHERE TRUNC(l_start_date) IN (SELECT DISTINCT START_DATE FROM OZF_TIME_ENT_QTR)
   AND TRUNC(l_end_date) IN (SELECT DISTINCT END_DATE FROM OZF_TIME_ENT_QTR);

Line: 384

  SELECT COUNT(ent_period_id)
    FROM OZF_TIME_ENT_PERIOD
   WHERE START_DATE >= TRUNC(p_start_date)
     AND END_DATE <= TRUNC(p_end_date);