APPS.IGS_PR_GEN_002 dependencies on IGS_CA_TYPE

Line 317: FROM IGS_CA_TYPE cat,

313: CURSOR c_cat_ci (
314: cp_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE) IS
315: SELECT ci1.cal_type,
316: ci1.sequence_number
317: FROM IGS_CA_TYPE cat,
318: IGS_CA_STAT cs,
319: IGS_CA_INST ci1
320: WHERE cat.cal_type = ci1.cal_type AND
321: cat.s_cal_cat = cst_progress AND

Line 503: IGS_CA_TYPE ct,

499: SELECT cir.sup_cal_type,
500: cir.sup_ci_sequence_number
501: FROM IGS_CA_INST ci1,
502: IGS_CA_INST_REL cir,
503: IGS_CA_TYPE ct,
504: IGS_CA_STAT cs
505: WHERE cir.sub_cal_type = p_cal_type AND
506: cir.sub_ci_sequence_number = p_ci_sequence_number AND
507: ct.cal_type = cir.sup_cal_type AND

Line 529: IGS_CA_TYPE ct,

525: cp_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE) IS
526: SELECT 'X'
527: FROM IGS_CA_INST ci1,
528: IGS_CA_INST_REL cir,
529: IGS_CA_TYPE ct,
530: IGS_CA_STAT cs
531: WHERE cir.sub_cal_type = p_cal_type AND
532: cir.sub_ci_sequence_number = p_ci_sequence_number AND
533: ct.cal_type = cir.sup_cal_type AND