DBA Data[Home] [Help]

APPS.IGS_AS_SU_STMPTOUT_PKG dependencies on IGS_AS_INC_GRD_CPROF_V

Line 89: l_version_number igs_as_inc_grd_cprof.version_number%TYPE) IS

85:
86: CURSOR c_dead_line_with_org(l_incomplete_grade igs_as_inc_grd_cprof.incomplete_grade%TYPE,
87: l_org_unit_cd igs_as_inc_grd_cprof.org_unit_cd%TYPE,
88: l_grading_schema_cd igs_as_inc_grd_cprof.grading_schema_cd%TYPE,
89: l_version_number igs_as_inc_grd_cprof.version_number%TYPE) IS
90: SELECT incomplete_grade, org_unit_cd, comp_after_dt_alias, default_grade,
91: default_mark
92: FROM igs_as_inc_grd_cprof_v
93: WHERE incomplete_grade = l_incomplete_grade

Line 92: FROM igs_as_inc_grd_cprof_v

88: l_grading_schema_cd igs_as_inc_grd_cprof.grading_schema_cd%TYPE,
89: l_version_number igs_as_inc_grd_cprof.version_number%TYPE) IS
90: SELECT incomplete_grade, org_unit_cd, comp_after_dt_alias, default_grade,
91: default_mark
92: FROM igs_as_inc_grd_cprof_v
93: WHERE incomplete_grade = l_incomplete_grade
94: AND org_unit_cd = l_org_unit_cd
95: AND grading_schema_cd = l_grading_schema_cd
96: AND version_number = l_version_number;

Line 100: l_version_number igs_as_inc_grd_cprof.version_number%TYPE) IS

96: AND version_number = l_version_number;
97:
98: CURSOR c_dead_line(l_incomplete_grade igs_as_inc_grd_cprof.incomplete_grade%TYPE,
99: l_grading_schema_cd igs_as_inc_grd_cprof.grading_schema_cd%TYPE,
100: l_version_number igs_as_inc_grd_cprof.version_number%TYPE) IS
101: SELECT incomplete_grade, org_unit_cd, comp_after_dt_alias, default_grade,
102: default_mark
103: FROM igs_as_inc_grd_cprof_v
104: WHERE incomplete_grade = l_incomplete_grade

Line 103: FROM igs_as_inc_grd_cprof_v

99: l_grading_schema_cd igs_as_inc_grd_cprof.grading_schema_cd%TYPE,
100: l_version_number igs_as_inc_grd_cprof.version_number%TYPE) IS
101: SELECT incomplete_grade, org_unit_cd, comp_after_dt_alias, default_grade,
102: default_mark
103: FROM igs_as_inc_grd_cprof_v
104: WHERE incomplete_grade = l_incomplete_grade
105: AND grading_schema_cd = l_grading_schema_cd
106: AND version_number = l_version_number;
107: