APPS.MSC_CL_PRE_PROCESS dependencies on MSC_ST_SHIFT_NUM_S

Line 4462: SELECT msc_st_shift_num_s.NEXTVAL

4458:
4459: IF lv_shift_num_gen > 0 THEN
4460: lv_shift_num := rec2.shift_name;
4461: ELSE
4462: SELECT msc_st_shift_num_s.NEXTVAL
4463: INTO lv_shift_num
4464: FROM dual;
4465: END IF;
4466:

Line 54096: msc_st_shift_num_s.nextval,

54092: period_start_date,
54093: next_date-1,
54094: 'Month',
54095: TO_NUMBER(TO_CHAR(period_start_date,'YYYY')),
54096: msc_st_shift_num_s.nextval,
54097: --decode(period_sequence_num,1,1,2,1,3,1,4,2,5,2,6,2,7,3,8,3,9,3,4),
54098: decode(to_char(period_start_date,'MM'),1,1,2,1,3,1,4,2,5,2,6,2,7,3,8,3,9,3,4), -- bug 8613033
54099: period_name,
54100: 'N',

Line 54151: msc_st_shift_num_s.nextval,

54147: period_start_date,
54148: next_date-1,
54149: 'Month',
54150: TO_NUMBER(TO_CHAR(period_start_date,'YYYY')),
54151: msc_st_shift_num_s.nextval,
54152: --decode(period_sequence_num,1,1,2,1,3,1,4,2,5,2,6,2,7,3,8,3,9,3,4),
54153: decode(to_char(period_start_date,'MM'),1,1,2,1,3,1,4,2,5,2,6,2,7,3,8,3,9,3,4), -- bug 8613033
54154: period_name,
54155: 'N',