APPS.MSC_CL_PRE_PROCESS dependencies on MSC_ST_SHIFT_NUM_S

Line 4455: SELECT msc_st_shift_num_s.NEXTVAL

4451:
4452: IF lv_shift_num_gen > 0 THEN
4453: lv_shift_num := rec2.shift_name;
4454: ELSE
4455: SELECT msc_st_shift_num_s.NEXTVAL
4456: INTO lv_shift_num
4457: FROM dual;
4458: END IF;
4459:

Line 49212: msc_st_shift_num_s.nextval,

49208: period_start_date,
49209: next_date-1,
49210: 'Month',
49211: TO_NUMBER(TO_CHAR(period_start_date,'YYYY')),
49212: msc_st_shift_num_s.nextval,
49213: decode(period_sequence_num,1,1,2,1,3,1,4,2,5,2,6,2,7,3,8,3,9,3,4),
49214: period_name,
49215: 'N',
49216: 'LEGACY',

Line 49263: msc_st_shift_num_s.nextval,

49259: period_start_date,
49260: next_date-1,
49261: 'Month',
49262: TO_NUMBER(TO_CHAR(period_start_date,'YYYY')),
49263: msc_st_shift_num_s.nextval,
49264: decode(period_sequence_num,1,1,2,1,3,1,4,2,5,2,6,2,7,3,8,3,9,3,4),
49265: period_name,
49266: 'N',
49267: 'LEGACY',