APPS.IGS_AD_VAL_ACAI_FTR_OFFER dependencies on DUAL

Line 65: FROM dual;

61: AND acai_sequence_number = cp_acai_sequence_number;
62:
63: CURSOR c_get_candidature_sequence IS
64: SELECT igs_re_candidature_seq_num_s.nextval
65: FROM dual;
66:
67: l_get_candidature_sequence igs_re_candidature.sequence_number%TYPE;
68:
69: CURSOR c_get_thesis (cp_person_id igs_re_thesis_all.person_id%TYPE,

Line 78: FROM dual;

74: AND ca_sequence_number = cp_ca_sequence_number;
75:
76: CURSOR c_get_thesis_sequence IS
77: SELECT igs_re_thesis_seq_num_s.nextval
78: FROM dual;
79:
80: l_get_thesis_sequence igs_re_thesis_all.sequence_number%TYPE;
81:
82: CURSOR c_get_cdt_fld_of_sy (cp_person_id igs_re_cdt_fld_of_sy.person_id%TYPE,