eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IGS_RE_VAL_CSC dependencies on IGS_RE_GV_SEO_CLS_CD

Line 67: -- *IGS_RE_GV_SEO_CLS_CD.res_fcd_class_ind is the same for all

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
71: SELECT gscc.res_fcd_class_ind

Line 73: IGS_RE_GV_SEO_CLS_CD gscc

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;
77: CURSOR c_csc_seocc_gscc(

Line 76: v_res_fcd_class_ind IGS_RE_GV_SEO_CLS_CD.res_fcd_class_ind%TYPE;

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;
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,

Line 78: cp_res_fcd_class_ind IGS_RE_GV_SEO_CLS_CD.res_fcd_class_ind%TYPE)IS

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;
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

Line 82: IGS_RE_GV_SEO_CLS_CD 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
86: csc.seo_class_cd = seocc.seo_class_cd AND