APPS.IGS_RE_VAL_SEOCC dependencies on IGS_RE_GV_SEO_CLS_CD

Line 49: -- Validate if IGS_RE_GV_SEO_CLS_CD.govt_seo_class_cd is closed.

45: p_govt_seo_class_cd IN VARCHAR2 ,
46: p_message_name OUT NOCOPY VARCHAR2 )
47: RETURN BOOLEAN AS
48: BEGIN -- resp_val_gscc_closed
49: -- Validate if IGS_RE_GV_SEO_CLS_CD.govt_seo_class_cd is closed.
50: DECLARE
51: v_gscc_rec VARCHAR2(1);
52: CURSOR c_gscc IS
53: SELECT 'X'

Line 54: FROM IGS_RE_GV_SEO_CLS_CD

50: DECLARE
51: v_gscc_rec VARCHAR2(1);
52: CURSOR c_gscc IS
53: SELECT 'X'
54: FROM IGS_RE_GV_SEO_CLS_CD
55: WHERE govt_seo_class_cd = p_govt_seo_class_cd AND
56: closed_ind = 'Y';
57: BEGIN
58: p_message_name := NULL;