1303: --
1304: cursor csr_check_residence_loc(p_csr_tmp_date in date) is
1305: select null
1306: from per_assignments_f asg, 1307: per_addresses pad 1308: where asg.assignment_id = pay_sta_shd.g_old_rec.assignment_id
1309: and pad.person_id = asg.person_id
1310: and pad.primary_flag = 'Y'
1311: and nvl(pad.date_to, hr_api.g_eot) > p_csr_tmp_date