DBA Data[Home] [Help]

APPS.IGS_EN_GEN_008 dependencies on IGS_CA_TYPE

Line 1409: igs_ca_type cal

1405: CURSOR c_load_cal(p_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
1406: p_acad_seq_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE) IS
1407: SELECT rel.sub_cal_type, rel.sub_ci_sequence_number FROM igs_ca_inst_rel rel,
1408: igs_ca_inst ci,
1409: igs_ca_type cal
1410: WHERE rel.sup_cal_type = p_acad_cal_type
1411: AND rel.sup_ci_sequence_number = p_acad_seq_num
1412: AND rel.sub_cal_type = ci.cal_type
1413: AND rel.sub_ci_sequence_number = ci.sequence_number