DBA Data[Home] [Help]

APPS.IGS_AS_ADI_UPLD_UG_PKG dependencies on IGS_AS_GPC_PROGRAMS

Line 113: cp_grading_period_cd igs_as_gpc_programs.grading_period_cd%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
117: SELECT ROWID

Line 753: FROM igs_as_gpc_programs gpr

749: CURSOR c_gpc IS
750: SELECT 'X'
751: FROM DUAL
752: WHERE EXISTS ( SELECT 'X'
753: FROM igs_as_gpc_programs gpr
754: WHERE gpr.course_cd = p_course_cd
755: AND gpr.grading_period_cd = p_grading_period_cd)
756: OR EXISTS ( SELECT 'X'
757: FROM igs_en_stdnt_ps_att spa,