DBA Data[Home] [Help]

APPS.GHR_CPDF_EHRIS dependencies on PER_ADDRESSES

Line 1387: FROM PER_ADDRESSES

1383:
1384: CURSOR workaddcur IS
1385: select address_line1,address_line2, address_line3, region_3 address_line4,
1386: COUNTRY, REGION_2, TOWN_OR_CITY CITY,POSTAL_CODE, REGION_1 County
1387: FROM PER_ADDRESSES
1388: Where Address_type= 'FED_WA'
1389: AND Person_id = p_sr_person_id
1390: And trunc(p_sr_report_date) between date_from and
1391: nvl(date_to, p_sr_report_date);