APPS.OKS_SUBSCRIPTION_SCH_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 130

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

Line: 131

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

Line: 335

  INSERT INTO Oks_test_tbl
    (delivery_date,start_date,end_date)
    values  (l_rec_tbl(l_ind).delivery_date,l_rec_tbl(l_ind).start_date,l_rec_tbl(l_ind).end_date);*/

Line: 671

              SELECT LAST_DAY(l_act_dt) INTO l_mth_last_dt FROM dual;

Line: 830

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