APPS.IGS_PS_CREATE_GENERIC_PKG dependencies on IGS_CA_INST_REL

Line 2501: igs_ca_inst_rel cir

2497: AND ci.cal_type = cp_cal_type
2498: AND ci.sequence_number = cp_sequence_number
2499: AND ci.sequence_number IN (SELECT ci2.sequence_number
2500: FROM igs_ca_inst ci2,
2501: igs_ca_inst_rel cir
2502: WHERE ci2.cal_type = cir.sup_cal_type
2503: AND ci2.sequence_number = cir.sup_ci_sequence_number
2504: AND cir.sub_cal_type = l_c_cal_type
2505: AND cir.sub_ci_sequence_number = l_n_seq_num);

Line 7727: FROM igs_ca_inst_rel

7723:
7724: CURSOR cur_cal_teach(cp_load_cal igs_ca_teach_to_load_v.load_cal_type%TYPE,
7725: cp_load_seq igs_ca_teach_to_load_v.load_ci_sequence_number%TYPE) IS
7726: SELECT sup_cal_type,sup_ci_sequence_number
7727: FROM igs_ca_inst_rel
7728: WHERE sub_cal_type = cp_load_cal
7729: AND sub_ci_sequence_number = cp_load_seq;
7730:
7731: CURSOR cur_cal_load IS

Line 10397: FROM igs_ca_inst_rel

10393:
10394: CURSOR cur_cal_teach(cp_load_cal igs_ca_teach_to_load_v.load_cal_type%TYPE,
10395: cp_load_seq igs_ca_teach_to_load_v.load_ci_sequence_number%TYPE) IS
10396: SELECT sup_cal_type,sup_ci_sequence_number
10397: FROM igs_ca_inst_rel
10398: WHERE sub_cal_type = cp_load_cal
10399: AND sub_ci_sequence_number = cp_load_seq;
10400:
10401: CURSOR cur_cal_load IS