APPS.MSC_CL_PRE_PROCESS dependencies on MSC_ST_CALENDARS_S

Line 3815: lv_transaction_id msc_st_calendars.st_transaction_id%TYPE;

3811: lv_table_name VARCHAR2(32);
3812: lv_column_names VARCHAR2(5000); --stores concatenated column names
3813:
3814: lv_calendar_code msc_st_calendars.calendar_code%TYPE;
3815: lv_transaction_id msc_st_calendars.st_transaction_id%TYPE;
3816: lv_calendar_start_date msc_st_calendars.calendar_start_date%TYPE;
3817: lv_calendar_end_date msc_st_calendars.calendar_end_date%TYPE;
3818: lv_seq_num msc_st_workday_patterns.seq_num%TYPE := 0;
3819: lv_message_text msc_errors.error_text%TYPE;

Line 3968: SELECT msc_st_calendars_s.NEXTVAL

3964: ||'DAYS_OFF ||''~''||'
3965: ||'DELETED_FLAG';
3966:
3967: v_sql_stmt := 1;
3968: SELECT msc_st_calendars_s.NEXTVAL
3969: INTO lv_transaction_id
3970: FROM dual;
3971:
3972: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Refresh ID: '||v_refresh_id);