1423: FROM igs_uc_applicants app
1424: WHERE app.app_no = cp_appno;
1425:
1426: -- To validate against Country code.
1427: CURSOR validate_country_cur (p_code igs_uc_ref_country.country_code%TYPE) IS
1428: SELECT 'X'
1429: FROM igs_uc_ref_country
1430: WHERE country_code = p_code;
1431:
1425:
1426: -- To validate against Country code.
1427: CURSOR validate_country_cur (p_code igs_uc_ref_country.country_code%TYPE) IS
1428: SELECT 'X'
1429: FROM igs_uc_ref_country
1430: WHERE country_code = p_code;
1431:
1432: l_valid VARCHAR2(1); -- for holding fetch from cursors for rec exists check.
1433:
1837: FROM igs_uc_ref_apr
1838: WHERE dom = p_id;
1839:
1840: -- To validate against Country code.
1841: CURSOR validate_country_cur (p_code igs_uc_ref_country.country_code%TYPE) IS
1842: SELECT 'X'
1843: FROM igs_uc_ref_country
1844: WHERE country_code = p_code;
1845:
1839:
1840: -- To validate against Country code.
1841: CURSOR validate_country_cur (p_code igs_uc_ref_country.country_code%TYPE) IS
1842: SELECT 'X'
1843: FROM igs_uc_ref_country
1844: WHERE country_code = p_code;
1845:
1846:
1847: -- To Update Sent_to_HESA flag in IGS_UC_APP_STATS when Domicile APR value gets updated in Applicant's table.