APPS.IGS_EN_VAL_SUA dependencies on IGS_GE_S_GEN_CAL_CON

Line 525: IGS_GE_S_GEN_CAL_CON sgcc

521: ci.start_dt,
522: ci.end_dt
523: FROM IGS_CA_DA_INST_V daiv,
524: IGS_CA_INST ci,
525: IGS_GE_S_GEN_CAL_CON sgcc
526: WHERE daiv.cal_type = p_cal_type AND
527: daiv.ci_sequence_number = p_ci_sequence_number AND
528: daiv.dt_alias = sgcc.census_dt_alias AND
529: sgcc.s_control_num = 1 AND

Line 1267: v_census_dt_alias IGS_GE_S_GEN_CAL_CON.census_dt_alias%TYPE;

1263: RETURN boolean AS
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:

Line 1274: FROM IGS_GE_S_GEN_CAL_CON sgcc

1270: v_rec_found BOOLEAN := FALSE;
1271:
1272: CURSOR c_census_dt IS
1273: SELECT sgcc.census_dt_alias
1274: FROM IGS_GE_S_GEN_CAL_CON sgcc
1275: WHERE sgcc.s_control_num = 1;
1276: CURSOR c_sci_details
1277: (cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
1278: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE) IS

Line 1296: cp_census_dt IGS_GE_S_GEN_CAL_CON.census_dt_alias%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
1300: SELECT daiv.dt_alias

Line 1334: -- raise an exception if no IGS_GE_S_GEN_CAL_CON

1330: -- select the census date alias from the general
1331: -- calendar confiration table
1332: OPEN c_census_dt;
1333: FETCH c_census_dt INTO v_census_dt_alias;
1334: -- raise an exception if no IGS_GE_S_GEN_CAL_CON
1335: -- records are found
1336: IF (c_census_dt%NOTFOUND) THEN
1337: CLOSE c_census_dt;
1338: RAISE NO_SGCC_RECORDS_FOUND;

Line 3225: IGS_GE_S_GEN_CAL_CON sgcc

3221: cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,
3222: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE) IS
3223: SELECT UNIQUE(daiv.alias_val) alias_val
3224: FROM IGS_CA_DA_INST_V daiv,
3225: IGS_GE_S_GEN_CAL_CON sgcc
3226: WHERE daiv.cal_type = cp_cal_type AND
3227: daiv.ci_sequence_number = cp_ci_sequence_number AND
3228: daiv.dt_alias = sgcc.census_dt_alias AND
3229: sgcc.s_control_num = 1;