APPS.IGS_EN_VAL_SUA dependencies on IGS_EN_STDNT_PS_ATT_ALL

Line 117: CURSOR c_com_dt(p_person_id IGS_EN_STDNT_PS_ATT_ALL.Person_id%TYPE,

113: rsup.end_dt >= v_teach_start_dt)
114: ORDER BY rsup.start_dt ASC;
115:
116: --tray
117: CURSOR c_com_dt(p_person_id IGS_EN_STDNT_PS_ATT_ALL.Person_id%TYPE,
118: p_course_cd IGS_EN_STDNT_PS_ATT_ALL.Course_cd%TYPE)IS
119: SELECT commencement_dt from igs_en_stdnt_ps_att_all
120: WHERE person_id = p_person_id
121: AND course_cd = p_course_cd;

Line 118: p_course_cd IGS_EN_STDNT_PS_ATT_ALL.Course_cd%TYPE)IS

114: ORDER BY rsup.start_dt ASC;
115:
116: --tray
117: CURSOR c_com_dt(p_person_id IGS_EN_STDNT_PS_ATT_ALL.Person_id%TYPE,
118: p_course_cd IGS_EN_STDNT_PS_ATT_ALL.Course_cd%TYPE)IS
119: SELECT commencement_dt from igs_en_stdnt_ps_att_all
120: WHERE person_id = p_person_id
121: AND course_cd = p_course_cd;
122: v_commencement_dt igs_en_stdnt_ps_att_all.commencement_dt%TYPE;

Line 119: SELECT commencement_dt from igs_en_stdnt_ps_att_all

115:
116: --tray
117: CURSOR c_com_dt(p_person_id IGS_EN_STDNT_PS_ATT_ALL.Person_id%TYPE,
118: p_course_cd IGS_EN_STDNT_PS_ATT_ALL.Course_cd%TYPE)IS
119: SELECT commencement_dt from igs_en_stdnt_ps_att_all
120: WHERE person_id = p_person_id
121: AND course_cd = p_course_cd;
122: v_commencement_dt igs_en_stdnt_ps_att_all.commencement_dt%TYPE;
123:

Line 122: v_commencement_dt igs_en_stdnt_ps_att_all.commencement_dt%TYPE;

118: p_course_cd IGS_EN_STDNT_PS_ATT_ALL.Course_cd%TYPE)IS
119: SELECT commencement_dt from igs_en_stdnt_ps_att_all
120: WHERE person_id = p_person_id
121: AND course_cd = p_course_cd;
122: v_commencement_dt igs_en_stdnt_ps_att_all.commencement_dt%TYPE;
123:
124: FUNCTION respl_check_percentage(
125: pl_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE,
126: pl_check_dt IGS_RE_SPRVSR.start_dt%TYPE)