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 548: SELECT gem5_matl_rep_id_s.NEXTVAL

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