APPS.PAY_IE_P45_ARCHIVE dependencies on PER_ADDRESSES

Line 2972: per_addresses pa ,

2968: FROM per_contact_relationships con,
2969: PER_ALL_PEOPLE_F paf1,
2970: PER_ALL_PEOPLE_F paf2,
2971: fnd_lookup_values c ,
2972: per_addresses pa ,
2973: fnd_lookup_values flv
2974: WHERE paf1.PERSON_ID = p_person_id
2975: and l_termination_date between paf1.EFFECTIVE_START_DATE and paf1.EFFECTIVE_END_DATE
2976: and con.PERSON_ID=paf1.PERSON_ID and con.BUSINESS_GROUP_ID =paf1.BUSINESS_GROUP_ID