DBA Data[Home] [Help]

APPS.PAY_US_ONLINE_W4_XML_PKG dependencies on PER_ADDRESSES

Line 90: FROM per_people_f ppf, per_addresses pad

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