APPS.HR_CAL_ABS_DUR_PKG SQL Statements

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

Line: 137

                SELECT p_duration + (((SUBSTR(l_day_end_time,1,2)*60 + SUBSTR(l_day_end_time,4,2)) -
                                      (SUBSTR(l_start_time,1,2)*60 + SUBSTR(l_start_time,4,2)))/60)
                INTO p_duration
                FROM DUAL;

Line: 144

                SELECT p_duration + (((SUBSTR(l_end_time,1,2)*60 + SUBSTR(l_end_time,4,2)) -
                                      (SUBSTR(l_day_start_time,1,2)*60 + SUBSTR(l_day_start_time,4,2)) + 1)/60)
                INTO p_duration
                FROM DUAL;

Line: 150

                SELECT p_duration + ((TRUNC(l_schedule(l_idx).END_DATE_TIME) - TRUNC(l_schedule(l_idx).START_DATE_TIME) - 1) * 24)
                INTO p_duration
                FROM DUAL;

Line: 157

                SELECT p_duration + (((SUBSTR(l_end_time,1,2)*60 + SUBSTR(l_end_time,4,2)) -
                                      (SUBSTR(l_start_time,1,2)*60 + SUBSTR(l_start_time,4,2)))/60)
                INTO p_duration
                FROM DUAL;

Line: 255

      select formula_id, effective_start_date
      into l_formula_id, l_effective_start_date
      from ff_formulas_f
      where formula_name = 'BG_ABSENCE_DURATION'
      and business_group_id = p_business_group_id
      and p_session_date between effective_start_date and effective_end_date;

Line: 266

          select formula_id, effective_start_date
          into l_formula_id, l_effective_start_date
          from ff_formulas_f
          where formula_name = 'LEGISLATION_ABSENCE_DURATION'
          and legislation_code = p_legislation_code
          and business_group_id is null
          and p_session_date between effective_start_date and effective_end_date;

Line: 278

              select formula_id, effective_start_date
              into l_formula_id, l_effective_start_date
              from ff_formulas_f
              where formula_name = 'CORE_ABSENCE_DURATION'
              and legislation_code is null
              and business_group_id is null
              and p_session_date between effective_start_date and effective_end_date;