APPS.OKS_SUBSCRIPTION_SCH_PVT dependencies on DUAL

Line 130: SELECT TO_CHAR(p_start_dt,'YYYY') INTO l_low_yr FROM DUAL;

126: END IF;
127:
128: IF p_pattern_tbl(l_ind).yr_pattern = '*' THEN
129:
130: SELECT TO_CHAR(p_start_dt,'YYYY') INTO l_low_yr FROM DUAL;
131: SELECT TO_CHAR(p_end_dt,'YYYY') INTO l_high_yr FROM DUAL;
132:
133: if l_low_yr = l_high_yr THEN
134: l_def := l_low_yr;

Line 131: SELECT TO_CHAR(p_end_dt,'YYYY') INTO l_high_yr FROM DUAL;

127:
128: IF p_pattern_tbl(l_ind).yr_pattern = '*' THEN
129:
130: SELECT TO_CHAR(p_start_dt,'YYYY') INTO l_low_yr FROM DUAL;
131: SELECT TO_CHAR(p_end_dt,'YYYY') INTO l_high_yr FROM DUAL;
132:
133: if l_low_yr = l_high_yr THEN
134: l_def := l_low_yr;
135: ELSE

Line 671: SELECT LAST_DAY(l_act_dt) INTO l_mth_last_dt FROM dual;

667: ELSE
668: x_rec_tbl(l_index).delivery_date := l_act_dt + p_offset_dy;
669: END IF;
670:
671: SELECT LAST_DAY(l_act_dt) INTO l_mth_last_dt FROM dual;
672: x_rec_tbl(l_index).start_date := l_act_dt;
673: x_rec_tbl(l_index).end_date := l_mth_last_dt;
674:
675: END IF; ---end of already exists.

Line 830: SELECT LAST_DAY(TO_DATE(l_first_dt,'YYYYMMDD')) INTO l_last_dt FROM dual; --last day of mth

826: FOR l_mth IN p_mth_pattern_tbl.FIRST..p_mth_pattern_tbl.LAST LOOP
827:
828: l_first_dt := p_yr_pattern_tbl(l_yr).num_item || p_mth_pattern_tbl(l_mth).num_item || '01';
829:
830: SELECT LAST_DAY(TO_DATE(l_first_dt,'YYYYMMDD')) INTO l_last_dt FROM dual; --last day of mth
831:
832: l_max := TO_CHAR(l_last_dt,'YYYYMMDD');
833:
834: FOR l_dy IN p_day_pattern_tbl.FIRST..p_day_pattern_tbl.LAST LOOP