DBA Data[Home] [Help]

APPS.PAY_CTY_BUS dependencies on HR_LOCATIONS

Line 1149: hr_locations hrl

1145: cursor chk_city_work(p_csr_tmp_date in date)
1146: is
1147: select hrl.location_id
1148: from per_assignments_f paf,
1149: hr_locations hrl
1150: where paf.assignment_id = p_assignment_id
1151: and hrl.location_id = paf.location_id
1152: and paf.effective_end_date > p_csr_tmp_date
1153: and exists (select null