APPS.IGS_PS_GEN_001 dependencies on IGS_PS_PAT_STUDY_UNT_SEQ_NUM_S

Line 928: SELECT IGS_PS_PAT_STUDY_UNT_SEQ_NUM_S.NEXTVAL

924: CURSOR c_posp_seq_num IS
925: SELECT IGS_PS_PAT_STUDY_UNT_POSPSEQ_S.NEXTVAL
926: FROM DUAL;
927: CURSOR c_posu_seq_num IS
928: SELECT IGS_PS_PAT_STUDY_UNT_SEQ_NUM_S.NEXTVAL
929: FROM DUAL;
930: CURSOR c_pos IS
931: SELECT pos.cal_type,
932: pos.sequence_number,