APPS.IGS_UC_PROC_APPLICATION_DATA dependencies on IGS_UC_REF_CODES

Line 1819: CURSOR validate_refcodes_cur (p_type igs_uc_ref_codes.code_type%TYPE,

1815: FROM igs_uc_applicants appl
1816: WHERE appl.app_no = p_appno;
1817:
1818: -- To validate SPECIALNEEDS, RESCAT, FEEPAYER, STATUS against Reference codes.
1819: CURSOR validate_refcodes_cur (p_type igs_uc_ref_codes.code_type%TYPE,
1820: p_code igs_uc_ref_codes.code%TYPE) IS
1821: SELECT 'X'
1822: FROM igs_uc_ref_codes
1823: WHERE code_type = p_type

Line 1820: p_code igs_uc_ref_codes.code%TYPE) IS

1816: WHERE appl.app_no = p_appno;
1817:
1818: -- To validate SPECIALNEEDS, RESCAT, FEEPAYER, STATUS against Reference codes.
1819: CURSOR validate_refcodes_cur (p_type igs_uc_ref_codes.code_type%TYPE,
1820: p_code igs_uc_ref_codes.code%TYPE) IS
1821: SELECT 'X'
1822: FROM igs_uc_ref_codes
1823: WHERE code_type = p_type
1824: AND code = p_code;

Line 1822: FROM igs_uc_ref_codes

1818: -- To validate SPECIALNEEDS, RESCAT, FEEPAYER, STATUS against Reference codes.
1819: CURSOR validate_refcodes_cur (p_type igs_uc_ref_codes.code_type%TYPE,
1820: p_code igs_uc_ref_codes.code%TYPE) IS
1821: SELECT 'X'
1822: FROM igs_uc_ref_codes
1823: WHERE code_type = p_type
1824: AND code = p_code;
1825:
1826:

Line 5087: FROM igs_uc_ref_codes

5083:
5084: -- validate ethnic value
5085: CURSOR validate_ethnic (p_ethnic igs_uc_istarx_ints.ethnic%TYPE) IS
5086: SELECT 'X'
5087: FROM igs_uc_ref_codes
5088: WHERE code_type = 'ET'
5089: and code = p_ethnic;
5090:
5091: -- validate Socialclass value

Line 5094: FROM igs_uc_ref_codes

5090:
5091: -- validate Socialclass value
5092: CURSOR validate_socialclass (p_socialclass igs_uc_istarx_ints.socialclass%TYPE) IS
5093: SELECT 'X'
5094: FROM igs_uc_ref_codes
5095: WHERE code_type = 'PC'
5096: AND code = p_socialclass;
5097:
5098: -- get the system and app_id to be populated into App Choices

Line 5396: FROM igs_uc_ref_codes

5392:
5393: -- validate ethnic value
5394: CURSOR validate_ethnic (p_ethnic igs_uc_istarh_ints.ethnic%TYPE) IS
5395: SELECT 'X'
5396: FROM igs_uc_ref_codes
5397: WHERE code_type = 'ET'
5398: and code = p_ethnic;
5399:
5400: -- validate Socialclass value

Line 5403: FROM igs_uc_ref_codes

5399:
5400: -- validate Socialclass value
5401: CURSOR validate_socialclass (p_socialclass igs_uc_istarh_ints.socialclass%TYPE) IS
5402: SELECT 'X'
5403: FROM igs_uc_ref_codes
5404: WHERE code_type = 'PC'
5405: AND code = p_socialclass;
5406:
5407: -- get the system and app_id to be populated into App Choices