APPS.IGS_AD_WRKFLOW_PKG dependencies on IGS_CA_TYPE

Line 210: , igs_ca_type t1

206: r.sub_cal_type,
207: r.sub_ci_sequence_number
208: from
209: igs_ca_inst_rel r
210: , igs_ca_type t1
211: , igs_ca_type t2
212: , igs_ca_inst acad
213: , igs_ca_inst adm
214: where

Line 211: , igs_ca_type t2

207: r.sub_ci_sequence_number
208: from
209: igs_ca_inst_rel r
210: , igs_ca_type t1
211: , igs_ca_type t2
212: , igs_ca_inst acad
213: , igs_ca_inst adm
214: where
215: sup_cal_type = t1.cal_type

Line 298: , igs_ca_type t1

294: r.sub_cal_type,
295: r.sub_ci_sequence_number
296: from
297: igs_ca_inst_rel r
298: , igs_ca_type t1
299: , igs_ca_type t2
300: , igs_ca_inst acad
301: , igs_ca_inst adm
302: where

Line 299: , igs_ca_type t2

295: r.sub_ci_sequence_number
296: from
297: igs_ca_inst_rel r
298: , igs_ca_type t1
299: , igs_ca_type t2
300: , igs_ca_inst acad
301: , igs_ca_inst adm
302: where
303: sup_cal_type = t1.cal_type

Line 374: , igs_ca_type t1

370: r.sub_cal_type,
371: r.sub_ci_sequence_number
372: from
373: igs_ca_inst_rel r
374: , igs_ca_type t1
375: , igs_ca_type t2
376: , igs_ca_inst acad
377: , igs_ca_inst adm
378: where

Line 375: , igs_ca_type t2

371: r.sub_ci_sequence_number
372: from
373: igs_ca_inst_rel r
374: , igs_ca_type t1
375: , igs_ca_type t2
376: , igs_ca_inst acad
377: , igs_ca_inst adm
378: where
379: sup_cal_type = t1.cal_type

Line 466: , igs_ca_type t1

462: r.sub_cal_type,
463: r.sub_ci_sequence_number
464: from
465: igs_ca_inst_rel r
466: , igs_ca_type t1
467: , igs_ca_type t2
468: , igs_ca_inst acad
469: , igs_ca_inst adm
470: where

Line 467: , igs_ca_type t2

463: r.sub_ci_sequence_number
464: from
465: igs_ca_inst_rel r
466: , igs_ca_type t1
467: , igs_ca_type t2
468: , igs_ca_inst acad
469: , igs_ca_inst adm
470: where
471: sup_cal_type = t1.cal_type