APPS.IGF_AP_PROFILE_MATCHING_PKG dependencies on IGS_AD_CAL_CONF

Line 3162: FROM igs_ad_cal_conf;

3158: */
3159:
3160: CURSOR cur_adm_cal_conf IS
3161: SELECT inq_cal_type
3162: FROM igs_ad_cal_conf;
3163:
3164: CURSOR cur_person_type IS
3165: SELECT person_type_code
3166: FROM igs_pe_person_types

Line 3171: l_inq_cal_type igs_ad_cal_conf.inq_cal_type%TYPE;

3167: WHERE closed_ind = 'N'
3168: AND system_type = 'PROSPECT';
3169:
3170: l_person_type igs_pe_person_types.person_type_code%TYPE;
3171: l_inq_cal_type igs_ad_cal_conf.inq_cal_type%TYPE;
3172: l_rowid ROWID;
3173: l_adm_seq igs_ca_inst.sequence_number%TYPE;
3174: l_acad_cal_type igs_ca_type.cal_type%TYPE;
3175: l_acad_seq igs_ca_inst.sequence_number%TYPE;