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_PS_VAL_CFOS dependencies on IGS_PS_FIELD_STUDY_V

Line 58: cp_version_number igs_ps_field_study.version_number%TYPE )IS

54: WHERE course_cd = p_course_cd AND
55: version_number = p_version_number;
56:
57: CURSOR gc_percent(cp_course_cd igs_ps_field_study.course_cd%TYPE,
58: cp_version_number igs_ps_field_study.version_number%TYPE )IS
59: SELECT NVL(SUM(percentage),0) sum_per,fos_type_code
60: FROM IGS_PS_FIELD_STUDY_V
61: WHERE FOS_TYPE_CODE <> 'CIP'
62: AND course_cd = cp_course_cd

Line 60: FROM IGS_PS_FIELD_STUDY_V

56:
57: CURSOR gc_percent(cp_course_cd igs_ps_field_study.course_cd%TYPE,
58: cp_version_number igs_ps_field_study.version_number%TYPE )IS
59: SELECT NVL(SUM(percentage),0) sum_per,fos_type_code
60: FROM IGS_PS_FIELD_STUDY_V
61: WHERE FOS_TYPE_CODE <> 'CIP'
62: AND course_cd = cp_course_cd
63: AND version_number = cp_version_number
64: GROUP BY fos_type_code

Line 134: cp_version_number igs_ps_field_study.version_number%TYPE )IS

130: CV.version_number = p_version_number AND
131: CV.course_status = CS.course_status;
132:
133: CURSOR c_course_field_of_study (cp_course_cd igs_ps_field_study.course_cd%TYPE,
134: cp_version_number igs_ps_field_study.version_number%TYPE )IS
135: SELECT fos_type_code
136: FROM IGS_PS_FIELD_STUDY_V out_fos
137: WHERE FOS_TYPE_Code <> 'CIP'
138: AND course_cd = cp_course_cd

Line 136: FROM IGS_PS_FIELD_STUDY_V out_fos

132:
133: CURSOR c_course_field_of_study (cp_course_cd igs_ps_field_study.course_cd%TYPE,
134: cp_version_number igs_ps_field_study.version_number%TYPE )IS
135: SELECT fos_type_code
136: FROM IGS_PS_FIELD_STUDY_V out_fos
137: WHERE FOS_TYPE_Code <> 'CIP'
138: AND course_cd = cp_course_cd
139: AND version_number = cp_version_number
140: AND NOT EXISTS( SELECT in_fos.FOS_TYPE_Code

Line 141: FROM IGS_PS_FIELD_STUDY_V in_fos

137: WHERE FOS_TYPE_Code <> 'CIP'
138: AND course_cd = cp_course_cd
139: AND version_number = cp_version_number
140: AND NOT EXISTS( SELECT in_fos.FOS_TYPE_Code
141: FROM IGS_PS_FIELD_STUDY_V in_fos
142: WHERE in_fos.FOS_TYPE_Code = out_fos.FOS_TYPE_Code
143: AND in_fos.course_cd = out_fos.course_cd
144: AND in_fos.version_number = out_fos.version_number
145: AND major_field_ind = 'Y'