APPS.HR_PERSON_SWI dependencies on HZ_PERSON_PROFILES
Line 172: from hz_person_profiles hzp
168: -- Cursor to return party last update date
169: cursor csr_party_last_update_date(p_party_id number,
170: p_effective_date date) is
171: select hzp.last_update_date 172: from hz_person_profiles hzp 173: where hzp.party_id = p_party_id
174: and p_effective_date
175: between hzp.effective_start_date
176: and nvl(hzp.effective_end_date,hr_api.g_eot);