APPS.IGS_AD_PRC_TAC_OFFER dependencies on IGS_PE_LANGUAGE_CD

Line 1852: cp_language_cd IGS_PE_LANGUAGE_CD.language_cd%TYPE) IS

1848: FROM IGS_OR_INSTITUTION
1849: WHERE govt_institution_cd = p_institution_cd OR
1850: institution_cd = p_institution_cd;
1851: CURSOR c_lc (
1852: cp_language_cd IGS_PE_LANGUAGE_CD.language_cd%TYPE) IS
1853: SELECT DISTINCT(language_cd) language_cd
1854: FROM IGS_PE_LANGUAGE_CD
1855: WHERE govt_language_cd = cp_language_cd OR
1856: language_cd = cp_language_cd;

Line 1854: FROM IGS_PE_LANGUAGE_CD

1850: institution_cd = p_institution_cd;
1851: CURSOR c_lc (
1852: cp_language_cd IGS_PE_LANGUAGE_CD.language_cd%TYPE) IS
1853: SELECT DISTINCT(language_cd) language_cd
1854: FROM IGS_PE_LANGUAGE_CD
1855: WHERE govt_language_cd = cp_language_cd OR
1856: language_cd = cp_language_cd;
1857: CURSOR c_fos IS
1858: SELECT DISTINCT(field_of_study) field_of_study

Line 1878: v_language_cd IGS_PE_LANGUAGE_CD.language_cd%TYPE DEFAULT NULL;

1874: v_ins_rec c_ins%ROWTYPE;
1875: v_institution_cd IGS_AD_TER_EDU.institution_cd%TYPE DEFAULT NULL;
1876: v_language_of_tuition
1877: IGS_AD_TER_EDU.language_of_tuition%TYPE DEFAULT NULL;
1878: v_language_cd IGS_PE_LANGUAGE_CD.language_cd%TYPE DEFAULT NULL;
1879: v_tertiary_edu_lvl_qual
1880: IGS_AD_TER_EDU.tertiary_edu_lvl_qual%TYPE DEFAULT NULL;
1881: v_tertiary_edu_lvl_comp
1882: IGS_AD_TER_EDU.tertiary_edu_lvl_comp%TYPE DEFAULT NULL;