APPS.PKG_GMP_BUCKET_DATA dependencies on GEM5_MATL_REP_ID_S

Line 50: SELECT gem5_matl_rep_id_s.NEXTVAL

46: SELECT matl_rep_id
47: FROM ps_matl_hdr
48: WHERE matl_rep_id = V_matl_rep_id;
49: CURSOR Cur_matl_rep_id IS
50: SELECT gem5_matl_rep_id_s.NEXTVAL
51: FROM dual;
52: X_rows NUMBER DEFAULT 0;
53: prior_to_one NUMBER DEFAULT 0;
54: X_trans_date DATE;

Line 546: SELECT gem5_matl_rep_id_s.NEXTVAL

542: SELECT matl_rep_id
543: FROM ps_matl_hdr
544: WHERE matl_rep_id = V_matl_rep_id;
545: CURSOR Cur_matl_rep_id IS
546: SELECT gem5_matl_rep_id_s.NEXTVAL
547: FROM dual;
548: X_rows NUMBER DEFAULT 0;
549: X_trans_date DATE;
550: X_qty NUMBER DEFAULT 0;