DBA Data[Home] [Help]

APPS.GL_CALENDAR_PKG SQL Statements

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

Line: 39

      SELECT period_name
      INTO low_period_name
      FROM gl_date_period_map
      WHERE period_set_name = calendar_name
      AND   period_type = get_num_periods_in_date_range.period_type
      AND   accounting_date = start_date;
Line: 57

      SELECT period_name
      INTO high_period_name
      FROM gl_date_period_map
      WHERE period_set_name = calendar_name
      AND   period_type = get_num_periods_in_date_range.period_type
      AND   accounting_date = end_date;
Line: 78

        SELECT min(accounting_date)
        INTO unmapped_date
        FROM gl_date_period_map
        WHERE period_set_name = calendar_name
        AND   period_type = get_num_periods_in_date_range.period_type
        AND   accounting_date between start_date and end_date
        AND   period_name = 'NOT ASSIGNED';
Line: 95

    SELECT count(*)
    INTO num_periods
    FROM gl_periods
    WHERE period_set_name = calendar_name
    AND   period_type = get_num_periods_in_date_range.period_type
    AND   adjustment_period_flag = 'N'
    AND   start_date <= get_num_periods_in_date_range.end_date
    AND   end_date >= get_num_periods_in_date_range.start_date;