APPS.IGS_PS_GEN_008 dependencies on IGS_CA_TYPE

Line 1845: --- similar IGS_CA_TYPE).

1841: AS
1842: v_unit_offer_pat_rec IGS_PS_UNIT_OFR_PAT%ROWTYPE;
1843: --- This cursor is used to select the IGS_PS_UNIT offering pattern with the latest
1844: --- calendar instance (the join between the two tables is based on having
1845: --- similar IGS_CA_TYPE).
1846: CURSOR c_unit_offer_pat_rec IS
1847: SELECT *
1848: FROM IGS_PS_UNIT_OFR_PAT UOP
1849: WHERE UOP.unit_cd = p_unit_cd AND

Line 2968: FROM igs_ca_type ct,

2964: cp_teach_cal_type igs_ca_inst.cal_type%TYPE,
2965: cp_teach_seq_num igs_ca_inst.sequence_number%TYPE) IS
2966: SELECT ci.cal_type,
2967: ci.sequence_number
2968: FROM igs_ca_type ct,
2969: igs_ca_inst ci,
2970: igs_ca_inst_rel cir
2971: WHERE cir.sup_ci_sequence_number = ci.sequence_number
2972: AND cir.sup_cal_type = ci.cal_type

Line 2986: FROM IGS_CA_TYPE ct,

2982: cp_exam_cal_type IGS_CA_INST.cal_type%TYPE,
2983: cp_teach_cal_type IGS_CA_INST.cal_type%TYPE,
2984: cp_teach_seq_num IGS_CA_INST.sequence_number%TYPE) IS
2985: SELECT COUNT(ci.cal_type)
2986: FROM IGS_CA_TYPE ct,
2987: IGS_CA_INST ci,
2988: IGS_CA_INST_REL cir
2989: WHERE cir.sup_ci_sequence_number = ci.sequence_number
2990: AND cir.sup_cal_type = ci.cal_type