APPS.IGS_RE_VAL_RSUP dependencies on IGS_AD_PS_APPL

Line 51: cp_admin_appl_num IGS_AD_PS_APPL.admission_appl_number%TYPE,

47: WHERE ca.person_id = p_ca_person_id AND
48: ca.sequence_number = p_ca_sequence_number;
49: v_ca_rec c_ca%ROWTYPE;
50: CURSOR c_acai (
51: cp_admin_appl_num IGS_AD_PS_APPL.admission_appl_number%TYPE,
52: cp_nom_course_cd IGS_AD_PS_APPL.nominated_course_cd%TYPE,
53: cp_seq_number IGS_AD_PS_APPL_INST.sequence_number%TYPE)
54: IS
55: SELECT acai.course_cd,

Line 52: cp_nom_course_cd IGS_AD_PS_APPL.nominated_course_cd%TYPE,

48: ca.sequence_number = p_ca_sequence_number;
49: v_ca_rec c_ca%ROWTYPE;
50: CURSOR c_acai (
51: cp_admin_appl_num IGS_AD_PS_APPL.admission_appl_number%TYPE,
52: cp_nom_course_cd IGS_AD_PS_APPL.nominated_course_cd%TYPE,
53: cp_seq_number IGS_AD_PS_APPL_INST.sequence_number%TYPE)
54: IS
55: SELECT acai.course_cd,
56: acai.crv_version_number,

Line 53: cp_seq_number IGS_AD_PS_APPL_INST.sequence_number%TYPE)

49: v_ca_rec c_ca%ROWTYPE;
50: CURSOR c_acai (
51: cp_admin_appl_num IGS_AD_PS_APPL.admission_appl_number%TYPE,
52: cp_nom_course_cd IGS_AD_PS_APPL.nominated_course_cd%TYPE,
53: cp_seq_number IGS_AD_PS_APPL_INST.sequence_number%TYPE)
54: IS
55: SELECT acai.course_cd,
56: acai.crv_version_number,
57: acai.adm_outcome_status

Line 58: FROM IGS_AD_PS_APPL_INST acai

54: IS
55: SELECT acai.course_cd,
56: acai.crv_version_number,
57: acai.adm_outcome_status
58: FROM IGS_AD_PS_APPL_INST acai
59: WHERE acai.person_id = p_ca_person_id AND
60: acai.admission_appl_number = cp_admin_appl_num AND
61: acai.nominated_course_cd = cp_nom_course_cd AND
62: acai.sequence_number = cp_seq_number;