APPS.IGS_EN_NSC_PKG dependencies on HZ_PERSON_PROFILES

Line 1424: FROM hz_parties P, hz_person_profiles PP

1420: p.person_first_name given_names,
1421: p.person_middle_name middle_name,
1422: p.person_name_suffix suffix,
1423: pp.date_of_birth birth_dt
1424: FROM hz_parties P, hz_person_profiles PP
1425: WHERE p.party_id = p_student_data.student_id
1426: AND p.party_id = pp.party_id
1427: AND pp.content_source_type = 'USER_ENTERED'
1428: AND SYSDATE BETWEEN pp.effective_start_date AND NVL(pp.effective_end_date,SYSDATE);

Line 1787: FROM igs_pe_hz_parties pd, hz_person_profiles pp

1783:
1784: /* For deceased date..cursor is changed from igs_pe_person to underlying tables */
1785: CURSOR c_decease_date IS
1786: SELECT NVL(pp.date_of_death,SYSDATE)
1787: FROM igs_pe_hz_parties pd, hz_person_profiles pp
1788: WHERE DECODE(pp.date_of_death,NULL,NVL(pd.deceased_ind,'N'),'Y')='Y'
1789: AND pp.party_id = p_student_id
1790: AND pp.party_id = pd.party_id (+)
1791: AND pp.content_source_type = 'USER_ENTERED'