APPS.IGS_EN_VAL_SUA dependencies on IGS_CA_DA_INST_V

Line 523: FROM IGS_CA_DA_INST_V daiv,

519: CURSOR c_sua IS
520: SELECT daiv.alias_val,
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

Line 1301: FROM IGS_CA_DA_INST_V daiv

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
1304: daiv.dt_alias = cp_census_dt AND
1305: daiv.alias_val >= cp_start_dt AND

Line 3221: cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,

3217: cst_discontin CONSTANT VARCHAR2(10) := 'DISCONTIN';
3218: cst_pass CONSTANT VARCHAR2(10) := 'PASS';
3219: cst_incomp CONSTANT VARCHAR2(10) := 'INCOMP';
3220: CURSOR c_daiv (
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

Line 3222: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE) IS

3218: cst_pass CONSTANT VARCHAR2(10) := 'PASS';
3219: cst_incomp CONSTANT VARCHAR2(10) := 'INCOMP';
3220: CURSOR c_daiv (
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

Line 3224: FROM IGS_CA_DA_INST_V daiv,

3220: CURSOR c_daiv (
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

Line 3270: alias_val IGS_CA_DA_INST_V.alias_val%TYPE);

3266: WHERE uv.unit_cd = p_unit_cd AND
3267: uv.version_number = p_uv_version_number;
3268: v_sct_exists VARCHAR2(1);
3269: TYPE r_alias_val_record_type IS RECORD(
3270: alias_val IGS_CA_DA_INST_V.alias_val%TYPE);
3271: r_alias_val_record r_alias_val_record_type;
3272: TYPE t_alias_val_type IS TABLE OF r_alias_val_record%TYPE
3273: INDEX BY BINARY_INTEGER;
3274: v_alias_val_table t_alias_val_type;