355: FROM IGS_ST_CITIZENSHP_CD cic
356: WHERE cic.citizenship_cd = v_citizenship_cd;
357: CURSOR c_cnc IS
358: SELECT cnc.govt_country_cd
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
582: SELECT prcd.govt_perm_resident_cd
583: FROM IGS_PE_PERM_RES_CD prcd
584: WHERE prcd.perm_resident_cd = cp_perm_res_cd;
585: CURSOR c_country_dtls (
586: cp_country_cd IGS_PE_COUNTRY_CD.country_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 (
584: WHERE prcd.perm_resident_cd = cp_perm_res_cd;
585: CURSOR c_country_dtls (
586: cp_country_cd IGS_PE_COUNTRY_CD.country_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