APPS.IGS_FI_VAL_CFAR dependencies on IGS_LOOKUPS_VIEW
Line 301: v_location_type igs_lookups_view.lookup_code%TYPE;
297: BEGIN --finp_val_loc_closed
298: --Validate if IGS_EN_ATD_TYPE.attendance_type is closed
299: DECLARE
300: v_closed_ind VARCHAR2(1); 301: v_location_type igs_lookups_view.lookup_code%TYPE; 302: CURSOR c_loc IS
303: SELECT loc.closed_ind,
304: loc.location_type
305: FROM IGS_AD_LOCATION loc