DBA Data[Home] [Help]

APPS.IGS_PR_GEN_001 dependencies on IGS_CA_TYPE

Line 274: FROM IGS_CA_TYPE cat,

270: v_match_not_found BOOLEAN DEFAULT FALSE;
271: CURSOR c_cat_ci_cir_cs1 IS
272: SELECT cir.sub_cal_type,
273: cir.sub_ci_sequence_number
274: FROM IGS_CA_TYPE cat,
275: IGS_CA_INST ci,
276: IGS_CA_INST_REL cir,
277: IGS_CA_STAT cs
278: WHERE cir.sup_cal_type = p_prg_cal_type AND

Line 318: FROM IGS_CA_TYPE cat,

314: cp_sua_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
315: cp_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE) IS
316: SELECT cir.sup_cal_type,
317: cir.sup_ci_sequence_number
318: FROM IGS_CA_TYPE cat,
319: IGS_CA_INST ci1,
320: IGS_CA_INST_REL cir,
321: IGS_CA_STAT cs
322: WHERE cir.sub_cal_type = cp_sua_cal_type AND

Line 445: FROM IGS_CA_TYPE cat,

441: v_period_found BOOLEAN DEFAULT FALSE;
442: CURSOR c_cat_ci_cir_cs IS
443: SELECT cir.sub_cal_type,
444: cir.sub_ci_sequence_number
445: FROM IGS_CA_TYPE cat,
446: IGS_CA_INST ci,
447: IGS_CA_INST_REL cir,
448: IGS_CA_STAT cs
449: WHERE cir.sup_cal_type = p_prg_cal_type AND