APPS.IGS_PR_GEN_002 dependencies on IGS_CA_STAT

Line 318: IGS_CA_STAT cs,

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
322: cs.cal_status = ci1.cal_status AND

Line 504: IGS_CA_STAT cs

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
508: ct.s_cal_cat = cst_progress AND

Line 530: IGS_CA_STAT cs

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
534: ct.s_cal_cat = cst_progress AND