DBA Data[Home] [Help]

APPS.GHR_CPDF_EHRIS dependencies on PER_ADDRESSES

Line 1433: FROM PER_ADDRESSES

1429:
1430: CURSOR workaddcur IS
1431: select address_line1,address_line2, address_line3, region_3 address_line4,
1432: COUNTRY, REGION_2, TOWN_OR_CITY CITY,POSTAL_CODE, REGION_1 County
1433: FROM PER_ADDRESSES
1434: Where Address_type= 'FED_WA'
1435: AND Person_id = p_sr_person_id
1436: And trunc(p_sr_report_date) between date_from and
1437: nvl(date_to, p_sr_report_date);