APPS.IGS_RE_VAL_CSC dependencies on IGS_RE_SEO_CLASS_CD

Line 66: -- *IGS_RE_SEO_CLASS_CD is not closed.

62: RETURN BOOLEAN AS
63: BEGIN -- resp_val_csc_seocc
64: -- Description: This module validate cand_seo_class.seo_class_cd.
65: -- Validations are:
66: -- *IGS_RE_SEO_CLASS_CD is not closed.
67: -- *IGS_RE_GV_SEO_CLS_CD.res_fcd_class_ind is the same for all
68: -- IGS_RE_CAND_SEO_CLS for a research IGS_RE_CANDIDATURE.
69: DECLARE
70: CURSOR c_seocc_gscc IS

Line 72: FROM IGS_RE_SEO_CLASS_CD seocc,

68: -- IGS_RE_CAND_SEO_CLS for a research IGS_RE_CANDIDATURE.
69: DECLARE
70: CURSOR c_seocc_gscc IS
71: SELECT gscc.res_fcd_class_ind
72: FROM IGS_RE_SEO_CLASS_CD seocc,
73: IGS_RE_GV_SEO_CLS_CD gscc
74: WHERE seocc.seo_class_cd = p_seo_class_cd AND
75: seocc.govt_seo_class_cd = gscc.govt_seo_class_cd;
76: v_res_fcd_class_ind IGS_RE_GV_SEO_CLS_CD.res_fcd_class_ind%TYPE;

Line 81: IGS_RE_SEO_CLASS_CD seocc,

77: CURSOR c_csc_seocc_gscc(
78: cp_res_fcd_class_ind IGS_RE_GV_SEO_CLS_CD.res_fcd_class_ind%TYPE)IS
79: SELECT 'X'
80: FROM IGS_RE_CAND_SEO_CLS csc,
81: IGS_RE_SEO_CLASS_CD seocc,
82: IGS_RE_GV_SEO_CLS_CD gscc
83: WHERE csc.person_id = p_person_id AND
84: csc.ca_sequence_number = p_ca_sequence_number AND
85: csc.seo_class_cd <>p_seo_class_cd AND

Line 133: FROM IGS_RE_SEO_CLASS_CD seocc

129: DECLARE
130: v_seocc_exists VARCHAR2(1);
131: CURSOR c_seocc IS
132: SELECT 'X'
133: FROM IGS_RE_SEO_CLASS_CD seocc
134: WHERE seocc.seo_class_cd = p_seo_class_cd AND
135: seocc.closed_ind = 'Y';
136: BEGIN
137: p_message_name := null;