APPS.BIS_AUTOINC_SCHEDULE SQL Statements

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

Line: 93

select rowid, session_value, session_description, period_date, attribute_name
from bis_user_attributes
where dimension in('TIME','EDW_TIME_M')
and schedule_id = pScheduleId;

Line: 100

select attribute_name, session_description
from bis_user_attributes
where dimension in('ORGANIZATION','EDW_ORGANIZATION_M')
and schedule_id = pScheduleId;

Line: 107

select increment_dates
from fnd_concurrent_requests
where request_id in(
      select concurrent_request_id
      from bis_scheduler
      where schedule_id = pScheduleId);

Line: 131

      select sysdate
      into v_sys_date
      from dual;

Line: 213

            update bis_user_attributes set
                session_value = v_dimn_level_id_from,
                session_description = v_dimn_level_value_from,
                period_date = v_start_date_lov_from
                where rowid = v_rowid_from;

Line: 220

            update bis_user_attributes set
                session_value = v_dimn_level_id_to,
                session_description = v_dimn_level_value_to,
                period_date = v_end_date_lov_to
                where rowid = v_rowid_to;

Line: 227

            update bis_user_attributes set
                --session_value = to_char(v_sys_date, 'DD-MON-RRRR'),
                --session_description = to_char(v_sys_date, 'DD-MON-RRRR'),
                --As of Date 3094234--dd/mm/rrrr format
                session_value = to_char(v_sys_date, 'DD/MM/RRRR'),
                session_description = to_char(v_sys_date, 'DD/MM/RRRR'),
                period_date = v_sys_date
                where schedule_id= pScheduleId
                and attribute_name='AS_OF_DATE';