1180: cursor chk_county_residence(p_csr_tmp_date in date)
1181: is
1182: select 1
1183: from per_assignments_f paf, 1184: per_addresses pa 1185: where paf.assignment_id = p_assignment_id
1186: and pa.person_id = paf.person_id
1187: and pa.primary_flag = 'Y'
1188: and nvl(pa.date_to, hr_api.g_eot) > p_csr_tmp_date
[Home] [Help]