eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_EN_VAL_SUA dependencies on IGS_EN_STDNT_PS_INTM

Line 1268: v_start_dt IGS_EN_STDNT_PS_INTM.start_dt%TYPE;

1264: BEGIN
1265: DECLARE
1266: NO_SGCC_RECORDS_FOUND EXCEPTION;
1267: v_census_dt_alias IGS_GE_S_GEN_CAL_CON.census_dt_alias%TYPE;
1268: v_start_dt IGS_EN_STDNT_PS_INTM.start_dt%TYPE;
1269: v_end_dt IGS_EN_STDNT_PS_INTM.end_dt%TYPE;
1270: v_rec_found BOOLEAN := FALSE;
1271:
1272: CURSOR c_census_dt IS

Line 1269: v_end_dt IGS_EN_STDNT_PS_INTM.end_dt%TYPE;

1265: DECLARE
1266: NO_SGCC_RECORDS_FOUND EXCEPTION;
1267: v_census_dt_alias IGS_GE_S_GEN_CAL_CON.census_dt_alias%TYPE;
1268: v_start_dt IGS_EN_STDNT_PS_INTM.start_dt%TYPE;
1269: v_end_dt IGS_EN_STDNT_PS_INTM.end_dt%TYPE;
1270: v_rec_found BOOLEAN := FALSE;
1271:
1272: CURSOR c_census_dt IS
1273: SELECT sgcc.census_dt_alias

Line 1282: FROM IGS_EN_STDNT_PS_INTM sci,

1278: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE) IS
1279: SELECT sci.start_dt,
1280: sci.end_dt,
1281: sci.cond_return_flag , sci.logical_delete_date
1282: FROM IGS_EN_STDNT_PS_INTM sci,
1283: IGS_EN_INTM_TYPES eit
1284: WHERE sci.person_id = cp_person_id AND
1285: sci.course_cd = cp_course_cd AND
1286: sci.approved = eit.appr_reqd_ind AND

Line 1295: cp_cond_ret_ind IGS_EN_STDNT_PS_INTM.cond_return_flag%TYPE,

1291: (cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1292: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
1293: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
1294: cp_ci_seq_num IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
1295: cp_cond_ret_ind IGS_EN_STDNT_PS_INTM.cond_return_flag%TYPE,
1296: cp_census_dt IGS_GE_S_GEN_CAL_CON.census_dt_alias%TYPE,
1297: cp_start_dt IGS_EN_STDNT_PS_INTM.start_dt%TYPE,
1298: cp_end_dt IGS_EN_STDNT_PS_INTM.end_dt%TYPE,
1299: cp_logical_del_dt IGS_EN_STDNT_PS_INTM.logical_delete_date%TYPE) IS

Line 1297: cp_start_dt IGS_EN_STDNT_PS_INTM.start_dt%TYPE,

1293: cp_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
1294: cp_ci_seq_num IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
1295: cp_cond_ret_ind IGS_EN_STDNT_PS_INTM.cond_return_flag%TYPE,
1296: cp_census_dt IGS_GE_S_GEN_CAL_CON.census_dt_alias%TYPE,
1297: cp_start_dt IGS_EN_STDNT_PS_INTM.start_dt%TYPE,
1298: cp_end_dt IGS_EN_STDNT_PS_INTM.end_dt%TYPE,
1299: cp_logical_del_dt IGS_EN_STDNT_PS_INTM.logical_delete_date%TYPE) IS
1300: SELECT daiv.dt_alias
1301: FROM IGS_CA_DA_INST_V daiv

Line 1298: cp_end_dt IGS_EN_STDNT_PS_INTM.end_dt%TYPE,

1294: cp_ci_seq_num IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
1295: cp_cond_ret_ind IGS_EN_STDNT_PS_INTM.cond_return_flag%TYPE,
1296: cp_census_dt IGS_GE_S_GEN_CAL_CON.census_dt_alias%TYPE,
1297: cp_start_dt IGS_EN_STDNT_PS_INTM.start_dt%TYPE,
1298: cp_end_dt IGS_EN_STDNT_PS_INTM.end_dt%TYPE,
1299: cp_logical_del_dt IGS_EN_STDNT_PS_INTM.logical_delete_date%TYPE) IS
1300: SELECT daiv.dt_alias
1301: FROM IGS_CA_DA_INST_V daiv
1302: WHERE daiv.cal_type = cp_cal_type AND

Line 1299: cp_logical_del_dt IGS_EN_STDNT_PS_INTM.logical_delete_date%TYPE) IS

1295: cp_cond_ret_ind IGS_EN_STDNT_PS_INTM.cond_return_flag%TYPE,
1296: cp_census_dt IGS_GE_S_GEN_CAL_CON.census_dt_alias%TYPE,
1297: cp_start_dt IGS_EN_STDNT_PS_INTM.start_dt%TYPE,
1298: cp_end_dt IGS_EN_STDNT_PS_INTM.end_dt%TYPE,
1299: cp_logical_del_dt IGS_EN_STDNT_PS_INTM.logical_delete_date%TYPE) IS
1300: SELECT daiv.dt_alias
1301: FROM IGS_CA_DA_INST_V daiv
1302: WHERE daiv.cal_type = cp_cal_type AND
1303: daiv.ci_sequence_number = cp_ci_seq_num AND