APPS.IGS_PE_GEN_004 dependencies on IGS_LOOKUP_VALUES

Line 35: cp_lookup_type igs_lookup_values.lookup_type%TYPE) IS

31: Who When What
32:
33: */
34: CURSOR race_dtls_cur (cp_person_id igs_pe_hz_parties.party_id%TYPE,
35: cp_lookup_type igs_lookup_values.lookup_type%TYPE) IS
36: SELECT lk.meaning
37: FROM igs_lookup_values lk, igs_pe_race race
38: WHERE race.person_id = cp_person_id AND
39: lk.lookup_type = cp_lookup_type AND

Line 37: FROM igs_lookup_values lk, igs_pe_race race

33: */
34: CURSOR race_dtls_cur (cp_person_id igs_pe_hz_parties.party_id%TYPE,
35: cp_lookup_type igs_lookup_values.lookup_type%TYPE) IS
36: SELECT lk.meaning
37: FROM igs_lookup_values lk, igs_pe_race race
38: WHERE race.person_id = cp_person_id AND
39: lk.lookup_type = cp_lookup_type AND
40: lk.lookup_code = race.race_cd;
41:

Line 776: FROM IGS_PE_PERSON_ALIAS ALIAS, IGS_LOOKUP_VALUES LKUP

772:
773: */
774: CURSOR cur_alias_type(cp_person_id NUMBER) IS
775: SELECT MEANING||': '||ALIAS.SURNAME||' '||ALIAS.GIVEN_NAMES OTHER_NAMES
776: FROM IGS_PE_PERSON_ALIAS ALIAS, IGS_LOOKUP_VALUES LKUP
777: WHERE ALIAS.ALIAS_TYPE = LKUP.LOOKUP_CODE
778: AND LKUP.LOOKUP_TYPE = 'PE_ALIAS_TYPE'
779: AND ALIAS.PERSON_ID = cp_person_id;
780: