APPS.IGS_PE_STAT_PKG dependencies on HZ_PERSON_PROFILES

Line 878: FROM hz_person_profiles xx ,

874: LV_PERSON_REC_TYPE Hz_Party_V2Pub.PERSON_REC_TYPE;
875: LV_PARTY_REC_TYPE Hz_Party_V2Pub.PARTY_REC_TYPE;
876: CURSOR party_cur IS
877: SELECT hp.last_update_date , xx.effective_start_date
878: FROM hz_person_profiles xx ,
879: hz_parties hp
880: WHERE xx.party_id = X_person_id AND
881: hp.party_id = xx.party_id AND
882: TRUNC(SYSDATE) BETWEEN TRUNC(xx.effective_start_date) AND