APPS.IGS_AV_GEN_001 dependencies on IGS_LOOKUPS_VIEW

Line 612: cst_granted_ge IGS_LOOKUPS_VIEW.lookup_code%TYPE;

608: cst_person CONSTANT VARCHAR2(10) := 'PERSON';
609: cst_all CONSTANT VARCHAR2(10) := 'ALL';
610: cst_approved CONSTANT VARCHAR2(10) := 'APPROVED';
611: cst_granted CONSTANT VARCHAR2(30) := 'GRANTED';
612: cst_granted_ge IGS_LOOKUPS_VIEW.lookup_code%TYPE;
613: v_total_exmptn_approved NUMBER(5);
614: v_total_exmptn_granted NUMBER(5);
615: v_total_exmptn_perc_grntd NUMBER(5);
616: v_granted_dt DATE;