APPS.EAM_FAILURECODES_PVT dependencies on EAM_FAILURE_SETS

Line 161: FROM eam_failure_sets

157: l_set_id := p_combination_rec.set_id;
158: ELSIF (p_combination_rec.set_name IS NOT NULL) THEN
159: SELECT min(set_id)
160: INTO l_set_id
161: FROM eam_failure_sets
162: WHERE set_name = p_combination_rec.set_name;
163:
164: IF (l_set_id IS NULL) THEN
165: Raise_Error ('EAM_FAILURESET_INVALID', 'FAILURE_SET', p_combination_rec.set_name);

Line 173: FROM eam_failure_sets

169: END IF;
170:
171: SELECT min(effective_end_date)
172: INTO l_set_end_date
173: FROM eam_failure_sets
174: WHERE set_id = l_set_id;
175:
176: IF (l_set_end_date IS NOT NULL AND
177: TRUNC(SYSDATE) > TRUNC(l_set_end_date)) THEN