APPS.GHR_DUT_BUS dependencies on PER_ASSIGNMENTS_F

Line 268: from per_assignments_f paf,hr_location_extra_info hrle

264: l_count NUMBER := 0;
265:
266: Cursor c_assgnments is
267: select '1'
268: from per_assignments_f paf,hr_location_extra_info hrle
269: where paf.location_id = hrle.location_id
270: and paf.assignment_type = 'E'
271: and p_effective_date between paf.effective_start_date and paf.effective_end_date
272: and hrle.lei_information_category = 'GHR_US_LOC_INFORMATION'