APPS.IGS_AS_VAL_VEA dependencies on HZ_LOCATIONS

Line 22: p_start_dt HZ_LOCATIONS.ADDRESS_EFFECTIVE_DATE%TYPE ,

18: -- Retrofitted
19: FUNCTION assp_val_vea_coraddr(
20: p_venue_cd IGS_AD_LOCVENUE_ADDR.location_venue_cd%TYPE ,
21: p_addr_type FND_LOOKUP_VALUES.LOOKUP_CODE%TYPE ,
22: p_start_dt HZ_LOCATIONS.ADDRESS_EFFECTIVE_DATE%TYPE ,
23: p_end_dt HZ_LOCATIONS.ADDRESS_EXPIRATION_DATE%TYPE ,
24: p_message_name OUT NOCOPY VARCHAR2 )
25: RETURN BOOLEAN;
26:

Line 23: p_end_dt HZ_LOCATIONS.ADDRESS_EXPIRATION_DATE%TYPE ,

19: FUNCTION assp_val_vea_coraddr(
20: p_venue_cd IGS_AD_LOCVENUE_ADDR.location_venue_cd%TYPE ,
21: p_addr_type FND_LOOKUP_VALUES.LOOKUP_CODE%TYPE ,
22: p_start_dt HZ_LOCATIONS.ADDRESS_EFFECTIVE_DATE%TYPE ,
23: p_end_dt HZ_LOCATIONS.ADDRESS_EXPIRATION_DATE%TYPE ,
24: p_message_name OUT NOCOPY VARCHAR2 )
25: RETURN BOOLEAN;
26:
27: --

Line 32: p_start_dt HZ_LOCATIONs.ADDRESS_EFFECTIVE_DATE%TYPE ,

28: -- Retrofitted
29: FUNCTION ASSP_VAL_VEA_OVRLP(
30: p_venue_cd IGS_AD_LOCVENUE_ADDR.location_venue_cd%TYPE ,
31: p_addr_type FND_LOOKUP_VALUES.LOOKUP_CODE%TYPE ,
32: p_start_dt HZ_LOCATIONs.ADDRESS_EFFECTIVE_DATE%TYPE ,
33: p_end_dt HZ_LOCATIONS.ADDRESS_EXPIRATION_DATE%TYPE ,
34: p_message_name OUT NOCOPY VARCHAR2 )
35: RETURN BOOLEAN;
36:

Line 33: p_end_dt HZ_LOCATIONS.ADDRESS_EXPIRATION_DATE%TYPE ,

29: FUNCTION ASSP_VAL_VEA_OVRLP(
30: p_venue_cd IGS_AD_LOCVENUE_ADDR.location_venue_cd%TYPE ,
31: p_addr_type FND_LOOKUP_VALUES.LOOKUP_CODE%TYPE ,
32: p_start_dt HZ_LOCATIONs.ADDRESS_EFFECTIVE_DATE%TYPE ,
33: p_end_dt HZ_LOCATIONS.ADDRESS_EXPIRATION_DATE%TYPE ,
34: p_message_name OUT NOCOPY VARCHAR2 )
35: RETURN BOOLEAN;
36:
37: --