DBA Data[Home] [Help]

APPS.IGS_FI_VAL_UFT dependencies on IGS_PS_UNIT_OFR_OPT

Line 177: FROM IGS_PS_UNIT_OFR_OPT uoo

173: DECLARE
174: v_dummy VARCHAR2(1);
175: CURSOR c_uoo IS
176: SELECT 'X'
177: FROM IGS_PS_UNIT_OFR_OPT uoo
178: WHERE uoo.unit_cd = p_unit_cd AND
179: (p_cal_type IS NULL OR
180: uoo.cal_type = p_cal_type) AND
181: (p_ci_sequence_number IS NULL OR

Line 194: -- 2. Check for IGS_PS_UNIT_OFR_OPT records for the unit_cd,

190: IF (p_unit_cd IS NULL) THEN
191: p_message_name := null;
192: RETURN TRUE;
193: END IF;
194: -- 2. Check for IGS_PS_UNIT_OFR_OPT records for the unit_cd,
195: -- location_cd, unit_class and cal_type
196: OPEN c_uoo;
197: FETCH c_uoo INTO v_dummy;
198: IF (c_uoo%NOTFOUND) THEN