APPS.PAY_US_ONLINE_W4_XML_PKG dependencies on PER_ADDRESSES

Line 86: FROM per_people_f ppf, per_addresses pad

82: pad.address_line1,
83: pad.address_line2,
84: pad.address_line3,
85: pad.town_or_city || ', ' || pad.region_2 || ', ' || pad.postal_code city_town_zip
86: FROM per_people_f ppf, per_addresses pad
87: WHERE ppf.person_id = cp_person_id
88: AND ppf.person_id = pad.person_id
89: AND trunc(sysdate) between ppf.effective_start_date
90: and ppf.effective_end_date