APPS.IGS_PE_GEN_004 dependencies on IGS_PE_HZ_PARTIES

Line 34: CURSOR race_dtls_cur (cp_person_id igs_pe_hz_parties.party_id%TYPE,

30: Change History:
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

Line 961: If not then check whether deceased_ind is set in the IGS_PE_HZ_PARTIES table.

957: ) RETURN VARCHAR2 AS
958: /*
959: Purpose: This functions returns the deceased indicator.
960: First it checks whether whether date_od_death is present in HZ_PERSON_PROFILES
961: If not then check whether deceased_ind is set in the IGS_PE_HZ_PARTIES table.
962:
963: Change History:
964: Who When What
965:

Line 975: FROM igs_pe_hz_parties

971: WHERE person_id = cp_person_id;
972:
973: CURSOR igs_dod_cur(cp_person_id NUMBER) IS
974: SELECT deceased_ind
975: FROM igs_pe_hz_parties
976: WHERE party_id = cp_person_id;
977:
978: l_date_of_death DATE;
979: l_deceased_ind VARCHAR2(1);