APPS.HR_MEE_VIEWS_GEN dependencies on PER_ALL_PEOPLE_F

Line 2006: per_all_people_f per

2002: select pcr.contact_type Contact_Type,
2003: decode(pcr.contact_type,'EMRG','Y','N') Emergency_Contact,
2004: HR_GENERAL.DECODE_LOOKUP('CONTACT',pcr.contact_type) Full_Contact_Type
2005: from per_contact_relationships pcr,
2006: per_all_people_f per
2007: where pcr.person_id = pp_person_id
2008: and pcr.contact_person_id = pp_contact_id
2009: and pcr.contact_person_id = per.person_id
2010: and pp_effective_date between

Line 2062: per_all_people_f per

2058:
2059: BEGIN
2060: select pcr.primary_contact_flag into lv_primary
2061: from per_contact_relationships pcr,
2062: per_all_people_f per
2063: where pcr.person_id = p_person_id
2064: and pcr.contact_person_id = p_contact_id
2065: and pcr.contact_person_id = per.person_id
2066: and p_effective_date between