APPS.IGS_EN_GEN_010 dependencies on IGS_AD_APPL

Line 412: IGS_AD_APPL aa,

408: acaiv.expected_completion_yr,
409: acaiv.expected_completion_perd,
410: acaiv.offer_dt
411: FROM IGS_AD_PS_APPL_INST acaiv,
412: IGS_AD_APPL aa,
413: IGS_AD_OU_STAT aos,
414: IGS_AD_OFR_RESP_STAT aors
415: WHERE
416: acaiv.person_id = p_person_id AND

Line 461: IGS_AD_APPL aa,

457: acaiv.expected_completion_yr,
458: acaiv.expected_completion_perd,
459: acaiv.offer_dt
460: FROM IGS_AD_PS_APPL_INST acaiv,
461: IGS_AD_APPL aa,
462: IGS_AD_OU_STAT aos,
463: IGS_AD_OFR_RESP_STAT aors
464: WHERE acaiv.person_id = p_person_id AND
465: acaiv.course_cd = p_course_cd AND

Line 4191: IGS_AD_APPL aa

4187: SELECT acaiv.unit_set_cd,
4188: acaiv.adm_cal_type,
4189: aa.admission_cat
4190: FROM IGS_AD_PS_APPL_INST acaiv,
4191: IGS_AD_APPL aa
4192: WHERE
4193: acaiv.person_id = p_person_id AND
4194: acaiv.admission_appl_number = cp_adm_admission_appl_number AND
4195: acaiv.nominated_course_cd = cp_adm_nominated_course_cd AND

Line 4214: v_admission_cat IGS_AD_APPL.admission_cat%TYPE;

4210: v_enrolment_cat IGS_EN_ENROLMENT_CAT.enrolment_cat%TYPE;
4211: v_enr_cat IGS_EN_ENROLMENT_CAT.enrolment_cat%TYPE;
4212: v_unit_set_cd IGS_AD_PS_APPL_INST_APLINST_V.unit_set_cd%TYPE;
4213: v_adm_cal_type IGS_AD_PS_APPL_INST_APLINST_V.adm_cal_type%TYPE;
4214: v_admission_cat IGS_AD_APPL.admission_cat%TYPE;
4215: v_warn_level VARCHAR2(10) ;
4216: v_log_creation_dt DATE;
4217: v_message_name VARCHAR2(2000);
4218: v_row_count NUMBER(1) := 0;

Line 6665: -- Create a history for an IGS_AD_APPL record

6661: p_old_update_on IN IGS_EN_SU_ATTEMPT_ALL.last_update_DATE%TYPE )
6662: AS
6663: gv_other_detail VARCHAR2(255);
6664: BEGIN -- enrp_ins_susa_hist
6665: -- Create a history for an IGS_AD_APPL record
6666: DECLARE
6667: v_susa_rec IGS_AS_SU_SETATMPT_H%ROWTYPE;
6668: v_create_history BOOLEAN := FALSE;
6669: BEGIN