492: SELECT birth_date
493: FROM igs_pe_person_base_v
494: WHERE person_id = cp_person_id;
495:
496: CURSOR chk_lkup_code(l_lookup_code igs_lookup_values.lookup_code%TYPE,
497: l_lookup_type igs_lookup_values.lookup_type%TYPE,
498: l_enabled_flag VARCHAR2)IS
499: SELECT NULL FROM IGS_LOOKUP_VALUES
500: WHERE lookup_type = l_lookup_type AND
493: FROM igs_pe_person_base_v
494: WHERE person_id = cp_person_id;
495:
496: CURSOR chk_lkup_code(l_lookup_code igs_lookup_values.lookup_code%TYPE,
497: l_lookup_type igs_lookup_values.lookup_type%TYPE,
498: l_enabled_flag VARCHAR2)IS
499: SELECT NULL FROM IGS_LOOKUP_VALUES
500: WHERE lookup_type = l_lookup_type AND
501: lookup_code = l_lookup_code AND
495:
496: CURSOR chk_lkup_code(l_lookup_code igs_lookup_values.lookup_code%TYPE,
497: l_lookup_type igs_lookup_values.lookup_type%TYPE,
498: l_enabled_flag VARCHAR2)IS
499: SELECT NULL FROM IGS_LOOKUP_VALUES
500: WHERE lookup_type = l_lookup_type AND
501: lookup_code = l_lookup_code AND
502: enabled_flag = l_enabled_flag;
503:
2151: CURSOR c_rating(cp_pe_cr_rec c_pe_cr_cur%ROWTYPE)IS
2152: SELECT
2153: 'X'
2154: FROM
2155: igs_lookup_values
2156: WHERE lookup_type = 'PE_CRE_RATING' AND
2157: lookup_code = cp_pe_cr_rec.rating_code AND
2158: enabled_flag = 'Y';
2159: