DBA Data[Home] [Help]

APPS.PAY_STA_BUS dependencies on HR_LOCATIONS

Line 1292: hr_locations hrl

1288: --
1289: cursor csr_check_work_loc(p_csr_tmp_date in date) is
1290: select null
1291: from per_assignments_f asg,
1292: hr_locations hrl
1293: where asg.assignment_id = pay_sta_shd.g_old_rec.assignment_id
1294: and hrl.location_id = asg.location_id
1295: and asg.effective_end_date > p_csr_tmp_date
1296: and exists (select null