APPS.IGS_ST_GEN_004 dependencies on IGS_GE_S_GEN_CAL_CON

Line 474: IGS_GE_S_GEN_CAL_CON sgcc

470: cp_teach_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,
471: cp_teach_ci_seq_num IGS_CA_DA_INST_V.ci_sequence_number%TYPE) IS
472: SELECT daiv.alias_val
473: FROM IGS_CA_DA_INST_V daiv,
474: IGS_GE_S_GEN_CAL_CON sgcc
475: WHERE daiv.cal_type = cp_teach_cal_type AND
476: daiv.ci_sequence_number = cp_teach_ci_seq_num AND
477: daiv.dt_alias = sgcc.census_dt_alias
478: ORDER BY daiv.alias_val ASC;

Line 2905: IGS_GE_S_GEN_CAL_CON sgcc

2901: cp_sua_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,
2902: cp_sua_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE) IS
2903: SELECT daiv.alias_val
2904: FROM IGS_CA_DA_INST_V daiv,
2905: IGS_GE_S_GEN_CAL_CON sgcc
2906: WHERE daiv.cal_type = cp_sua_cal_type AND
2907: daiv.ci_sequence_number = cp_sua_ci_sequence_number AND
2908: daiv.dt_alias = sgcc.census_dt_alias
2909: ORDER BY daiv.alias_val;