APPS.IGS_AS_ADI_UPLD_UG_PKG dependencies on IGS_AS_SU_ATMPT_ITM

Line 108: cp_person_id igs_as_su_atmpt_itm.person_id%TYPE,

104: --
105: --
106: --
107: CURSOR c_suao (
108: cp_person_id igs_as_su_atmpt_itm.person_id%TYPE,
109: cp_course_cd igs_as_su_atmpt_itm.course_cd%TYPE,
110: cp_unit_cd igs_as_su_atmpt_itm.unit_cd%TYPE,
111: cp_cal_type igs_as_su_atmpt_itm.cal_type%TYPE,
112: cp_ci_sequence_number igs_as_su_atmpt_itm.ci_sequence_number%TYPE,

Line 109: cp_course_cd igs_as_su_atmpt_itm.course_cd%TYPE,

105: --
106: --
107: CURSOR c_suao (
108: cp_person_id igs_as_su_atmpt_itm.person_id%TYPE,
109: cp_course_cd igs_as_su_atmpt_itm.course_cd%TYPE,
110: cp_unit_cd igs_as_su_atmpt_itm.unit_cd%TYPE,
111: cp_cal_type igs_as_su_atmpt_itm.cal_type%TYPE,
112: cp_ci_sequence_number igs_as_su_atmpt_itm.ci_sequence_number%TYPE,
113: cp_grading_period_cd igs_as_gpc_programs.grading_period_cd%TYPE,

Line 110: cp_unit_cd igs_as_su_atmpt_itm.unit_cd%TYPE,

106: --
107: CURSOR c_suao (
108: cp_person_id igs_as_su_atmpt_itm.person_id%TYPE,
109: cp_course_cd igs_as_su_atmpt_itm.course_cd%TYPE,
110: cp_unit_cd igs_as_su_atmpt_itm.unit_cd%TYPE,
111: cp_cal_type igs_as_su_atmpt_itm.cal_type%TYPE,
112: cp_ci_sequence_number igs_as_su_atmpt_itm.ci_sequence_number%TYPE,
113: cp_grading_period_cd igs_as_gpc_programs.grading_period_cd%TYPE,
114: -- anilk, 22-Apr-2003, Bug# 2829262

Line 111: cp_cal_type igs_as_su_atmpt_itm.cal_type%TYPE,

107: CURSOR c_suao (
108: cp_person_id igs_as_su_atmpt_itm.person_id%TYPE,
109: cp_course_cd igs_as_su_atmpt_itm.course_cd%TYPE,
110: cp_unit_cd igs_as_su_atmpt_itm.unit_cd%TYPE,
111: cp_cal_type igs_as_su_atmpt_itm.cal_type%TYPE,
112: cp_ci_sequence_number igs_as_su_atmpt_itm.ci_sequence_number%TYPE,
113: cp_grading_period_cd igs_as_gpc_programs.grading_period_cd%TYPE,
114: -- anilk, 22-Apr-2003, Bug# 2829262
115: cp_uoo_id igs_as_su_atmpt_itm.uoo_id%TYPE

Line 112: cp_ci_sequence_number igs_as_su_atmpt_itm.ci_sequence_number%TYPE,

108: cp_person_id igs_as_su_atmpt_itm.person_id%TYPE,
109: cp_course_cd igs_as_su_atmpt_itm.course_cd%TYPE,
110: cp_unit_cd igs_as_su_atmpt_itm.unit_cd%TYPE,
111: cp_cal_type igs_as_su_atmpt_itm.cal_type%TYPE,
112: cp_ci_sequence_number igs_as_su_atmpt_itm.ci_sequence_number%TYPE,
113: cp_grading_period_cd igs_as_gpc_programs.grading_period_cd%TYPE,
114: -- anilk, 22-Apr-2003, Bug# 2829262
115: cp_uoo_id igs_as_su_atmpt_itm.uoo_id%TYPE
116: ) IS

Line 115: cp_uoo_id igs_as_su_atmpt_itm.uoo_id%TYPE

111: cp_cal_type igs_as_su_atmpt_itm.cal_type%TYPE,
112: cp_ci_sequence_number igs_as_su_atmpt_itm.ci_sequence_number%TYPE,
113: cp_grading_period_cd igs_as_gpc_programs.grading_period_cd%TYPE,
114: -- anilk, 22-Apr-2003, Bug# 2829262
115: cp_uoo_id igs_as_su_atmpt_itm.uoo_id%TYPE
116: ) IS
117: SELECT ROWID
118: FROM igs_as_su_stmptout_all suao
119: WHERE suao.person_id = cp_person_id