APPS.MSC_CL_PRE_PROCESS dependencies on MSC_ST_CALENDARS_S

Line 3822: lv_transaction_id msc_st_calendars.st_transaction_id%TYPE;

3818: lv_table_name VARCHAR2(32);
3819: lv_column_names VARCHAR2(5000); --stores concatenated column names
3820:
3821: lv_calendar_code msc_st_calendars.calendar_code%TYPE;
3822: lv_transaction_id msc_st_calendars.st_transaction_id%TYPE;
3823: lv_calendar_start_date msc_st_calendars.calendar_start_date%TYPE;
3824: lv_calendar_end_date msc_st_calendars.calendar_end_date%TYPE;
3825: lv_seq_num msc_st_workday_patterns.seq_num%TYPE := 0;
3826: lv_message_text msc_errors.error_text%TYPE;

Line 3975: SELECT msc_st_calendars_s.NEXTVAL

3971: ||'DAYS_OFF ||''~''||'
3972: ||'DELETED_FLAG';
3973:
3974: v_sql_stmt := 1;
3975: SELECT msc_st_calendars_s.NEXTVAL
3976: INTO lv_transaction_id
3977: FROM dual;
3978:
3979: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Refresh ID: '||v_refresh_id);