APPS.IGS_AD_PS_APPL_INST_PKG dependencies on IGS_RE_CANDIDATURE

Line 349: v_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;

345: v_appl_dt IGS_AD_APPL.appl_dt%TYPE;
346: v_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE;
347: v_adm_fee_status IGS_AD_APPL.adm_fee_status%TYPE;
348: v_transfer_course_cd IGS_AD_PS_APPL.transfer_course_cd%TYPE;
349: v_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;
350: v_pref_allowed_ind VARCHAR2(1) ;
351: v_pref_limit NUMBER;
352: v_cond_offer_doc_allowed_ind VARCHAR2(1) ;
353: v_cond_offer_fee_allowed_ind VARCHAR2(1) ;

Line 3361: IGS_RE_CANDIDATURE_PKG.GET_FK_IGS_AD_PS_APPL_INST (

3357: old_references.admission_appl_number,
3358: old_references.nominated_course_cd,
3359: old_references.sequence_number
3360: );
3361: IGS_RE_CANDIDATURE_PKG.GET_FK_IGS_AD_PS_APPL_INST (
3362: old_references.person_id,
3363: old_references.admission_appl_number,
3364: old_references.nominated_course_cd,
3365: old_references.sequence_number