DBA Data[Home] [Help]

APPS.PAY_CNT_BUS dependencies on HR_LOCATIONS

Line 1162: hr_locations hrl

1158: cursor chk_county_work(p_csr_tmp_date in date)
1159: is
1160: select hrl.location_id
1161: from per_assignments_f paf,
1162: hr_locations hrl
1163: where paf.assignment_id = p_assignment_id
1164: and hrl.location_id = paf.location_id
1165: and paf.effective_end_date > p_csr_tmp_date
1166: and exists (select null