APPS.IGS_RE_GEN_001 dependencies on IGS_GE_S_GEN_CAL_CON

Line 64: IGS_GE_S_GEN_CAL_CON sgcc,

60: dai.sequence_number,
61: dai.cal_type,
62: dai.ci_sequence_number)) census_dt
63: FROM IGS_PS_UNIT_OFR_OPT uoo,
64: IGS_GE_S_GEN_CAL_CON sgcc,
65: IGS_CA_DA_INST dai
66: WHERE uoo.uoo_id = p_uoo_id AND
67: sgcc.s_control_num = 1 and
68: dai.dt_alias = sgcc.census_dt_alias AND

Line 842: FROM IGS_GE_S_GEN_CAL_CON sgcc,

838: dai.dt_alias,
839: dai.sequence_number,
840: dai.cal_type,
841: dai.ci_sequence_number)) v_census_dt
842: FROM IGS_GE_S_GEN_CAL_CON sgcc,
843: IGS_CA_DA_INST dai
844: WHERE sgcc.s_control_num = 1 AND
845: dai.cal_type = cp_cal_type AND
846: dai.ci_sequence_number = cp_ci_sequence_number AND