APPS.IGS_ST_GEN_002 dependencies on IGS_PE_LANGUAGE_CD

Line 363: FROM IGS_PE_LANGUAGE_CD lc

359: FROM IGS_PE_COUNTRY_CD cnc
360: WHERE cnc.country_cd = v_birth_country_cd;
361: CURSOR c_lc IS
362: SELECT lc.govt_language_cd
363: FROM IGS_PE_LANGUAGE_CD lc
364: WHERE lc.language_cd = v_home_language_cd;
365: BEGIN
366: OPEN c_pe;
367: FETCH c_pe INTO p_birth_dt,

Line 591: cp_language_cd IGS_PE_LANGUAGE_CD.language_cd%TYPE) IS

587: SELECT ccd.govt_country_cd
588: FROM IGS_PE_COUNTRY_CD ccd
589: WHERE ccd.country_cd = cp_country_cd;
590: CURSOR c_language (
591: cp_language_cd IGS_PE_LANGUAGE_CD.language_cd%TYPE) IS
592: SELECT lcd.govt_language_cd
593: FROM IGS_PE_LANGUAGE_CD lcd
594: WHERE lcd.language_cd = cp_language_cd;
595: CURSOR c_inst (

Line 593: FROM IGS_PE_LANGUAGE_CD lcd

589: WHERE ccd.country_cd = cp_country_cd;
590: CURSOR c_language (
591: cp_language_cd IGS_PE_LANGUAGE_CD.language_cd%TYPE) IS
592: SELECT lcd.govt_language_cd
593: FROM IGS_PE_LANGUAGE_CD lcd
594: WHERE lcd.language_cd = cp_language_cd;
595: CURSOR c_inst (
596: cp_prior_ug_inst IGS_OR_INSTITUTION.institution_cd%TYPE) IS
597: SELECT inst.govt_institution_cd