APPS.IGS_EN_GEN_010 dependencies on IGS_AD_ADM_UNIT_STAT

Line 5795: v_aus_description IGS_AD_ADM_UNIT_STAT.description%TYPE;

5791: BEGIN
5792: DECLARE
5793: r_suah IGS_EN_SU_ATTEMPT_H%ROWTYPE;
5794: v_create_history BOOLEAN := FALSE;
5795: v_aus_description IGS_AD_ADM_UNIT_STAT.description%TYPE;
5796: v_elo_description IGS_AD_LOCATION.description%TYPE;
5797:
5798: CURSOR c_find_aus_desc IS
5799: SELECT description

Line 5800: FROM IGS_AD_ADM_UNIT_STAT

5796: v_elo_description IGS_AD_LOCATION.description%TYPE;
5797:
5798: CURSOR c_find_aus_desc IS
5799: SELECT description
5800: FROM IGS_AD_ADM_UNIT_STAT
5801: WHERE administrative_unit_status = r_suah.administrative_unit_status;
5802: CURSOR c_find_elo_desc IS
5803: SELECT description
5804: FROM IGS_AD_LOCATION