APPS.IGS_AD_VAL_ACAI_FTR_OFFER dependencies on IGS_RE_THESIS_ALL

Line 69: CURSOR c_get_thesis (cp_person_id igs_re_thesis_all.person_id%TYPE,

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,
70: cp_ca_sequence_number igs_re_thesis_all.ca_sequence_number%TYPE) IS
71: SELECT *
72: FROM igs_re_thesis_all
73: WHERE person_id = cp_person_id

Line 70: cp_ca_sequence_number igs_re_thesis_all.ca_sequence_number%TYPE) IS

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,
70: cp_ca_sequence_number igs_re_thesis_all.ca_sequence_number%TYPE) IS
71: SELECT *
72: FROM igs_re_thesis_all
73: WHERE person_id = cp_person_id
74: AND ca_sequence_number = cp_ca_sequence_number;

Line 72: FROM igs_re_thesis_all

68:
69: CURSOR c_get_thesis (cp_person_id igs_re_thesis_all.person_id%TYPE,
70: cp_ca_sequence_number igs_re_thesis_all.ca_sequence_number%TYPE) IS
71: SELECT *
72: FROM igs_re_thesis_all
73: WHERE person_id = cp_person_id
74: AND ca_sequence_number = cp_ca_sequence_number;
75:
76: CURSOR c_get_thesis_sequence IS

Line 80: l_get_thesis_sequence igs_re_thesis_all.sequence_number%TYPE;

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,
83: cp_ca_sequence_number igs_re_cdt_fld_of_sy.ca_sequence_number%TYPE) IS
84: SELECT *