APPS.IGS_RE_VAL_SEOCC dependencies on IGS_RE_SEO_CLASS_CD

Line 10: -- This module validates whether a IGS_RE_SEO_CLASS_CD record currently exists

6: p_govt_seo_class_cd IN VARCHAR2 ,
7: p_message_name OUT NOCOPY VARCHAR2 )
8: RETURN BOOLEAN AS
9: BEGIN -- resp_val_scc_gscc
10: -- This module validates whether a IGS_RE_SEO_CLASS_CD record currently exists
11: -- with a govt_seo_class_cd = p_govt_seo_class_cd
12: DECLARE
13: v_count NUMBER;
14: CURSOR c_scc IS

Line 16: FROM IGS_RE_SEO_CLASS_CD

12: DECLARE
13: v_count NUMBER;
14: CURSOR c_scc IS
15: SELECT COUNT(govt_seo_class_cd)
16: FROM IGS_RE_SEO_CLASS_CD
17: WHERE govt_seo_class_cd = p_govt_seo_class_cd AND
18: closed_ind = 'N';
19: BEGIN
20: p_message_name := NULL;