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