DBA Data[Home] [Help]

APPS.PAY_STA_BUS dependencies on HR_LOCATIONS

Line 1295: hr_locations hrl

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