DBA Data[Home] [Help]

APPS.IGS_AS_ADI_UPLD_UG_PKG dependencies on IGS_AS_SU_STMPTOUT_ALL

Line 118: FROM igs_as_su_stmptout_all suao

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
120: AND suao.course_cd = cp_course_cd
121: AND suao.uoo_id = cp_uoo_id
122: AND suao.grading_period_cd = cp_grading_period_cd

Line 131: FROM igs_as_su_stmptout_all suao

127: CURSOR c_suao_record (
128: cp_rowid IN VARCHAR2
129: ) IS
130: SELECT suao.*
131: FROM igs_as_su_stmptout_all suao
132: WHERE ROWID = cp_rowid;
133: -- Declare local variables
134: v_person_id NUMBER (15);
135: v_cal_type VARCHAR2 (10);

Line 704: FROM igs_as_su_stmptout_all suao

700: ) IS
701: SELECT suao.mark,
702: suao.grade,
703: suao.finalised_outcome_ind
704: FROM igs_as_su_stmptout_all suao
705: WHERE suao.person_id = p_person_id
706: AND suao.course_cd = p_course_cd
707: -- anilk, 22-Apr-2003, Bug# 2829262
708: AND suao.uoo_id = cp_uoo_id