APPS.IGS_AD_VAL_ACAI dependencies on IGS_AD_UNIT_OU_STAT

Line 4781: IGS_AD_UNIT_OU_STAT.s_adm_outcome_status%TYPE := 'OFFER';

4777: BEGIN -- admp_val_acaiu_defer
4778: -- Validate the deferment of IGS_AD_PS_APLINSTUNT records
4779: DECLARE
4780: cst_offer CONSTANT
4781: IGS_AD_UNIT_OU_STAT.s_adm_outcome_status%TYPE := 'OFFER';
4782: v_message_name VARCHAR2(30);
4783: CURSOR c_acaiu_auos IS
4784: SELECT acaiu.unit_cd,
4785: acaiu.uv_version_number,

Line 4792: IGS_AD_UNIT_OU_STAT auos

4788: acaiu.location_cd,
4789: acaiu.unit_class,
4790: acaiu.unit_mode
4791: FROM IGS_AD_PS_APLINSTUNT acaiu,
4792: IGS_AD_UNIT_OU_STAT auos
4793: WHERE acaiu.person_id = p_person_id AND
4794: acaiu.admission_appl_number = p_admission_appl_number AND
4795: acaiu.nominated_course_cd = p_nominated_course_cd AND
4796: acaiu.acai_sequence_number = p_acai_sequence_number AND