APPS.IGS_FI_VAL_FAR dependencies on IGS_AD_LOCATION_TYPE

Line 94: v_s_location_type IGS_AD_LOCATION_TYPE.s_location_type%TYPE;

90: p_message_name OUT NOCOPY VARCHAR2 )
91: RETURN BOOLEAN AS
92: v_location_closed_ind IGS_AD_LOCATION.closed_ind%TYPE;
93: v_location_type IGS_AD_LOCATION.location_type%TYPE;
94: v_s_location_type IGS_AD_LOCATION_TYPE.s_location_type%TYPE;
95: CURSOR c_location_cd(
96: cp_location_cd IGS_AD_LOCATION.location_cd%TYPE) IS
97: SELECT IGS_AD_LOCATION.closed_ind,
98: location_type

Line 102: cp_location_type IGS_AD_LOCATION_TYPE.location_type%TYPE) IS

98: location_type
99: FROM IGS_AD_LOCATION
100: WHERE location_cd = cp_location_cd;
101: CURSOR c_location_type(
102: cp_location_type IGS_AD_LOCATION_TYPE.location_type%TYPE) IS
103: SELECT s_location_type
104: FROM IGS_AD_LOCATION_TYPE
105: WHERE location_type = cp_location_type;
106: v_other_detail VARCHAR2(255);

Line 104: FROM IGS_AD_LOCATION_TYPE

100: WHERE location_cd = cp_location_cd;
101: CURSOR c_location_type(
102: cp_location_type IGS_AD_LOCATION_TYPE.location_type%TYPE) IS
103: SELECT s_location_type
104: FROM IGS_AD_LOCATION_TYPE
105: WHERE location_type = cp_location_type;
106: v_other_detail VARCHAR2(255);
107: BEGIN
108: -- This module based on the parameter performs validations