APPS.GHR_GHRWS52L dependencies on PER_ASSIGNMENTS_F

Line 249: WHERE TABLE_NAME = 'PER_ASSIGNMENTS_F'

245:
246: CURSOR c_prior_ds_date (p_assignment_id in number) is
247: SELECT FND_DATE.CANONICAL_TO_DATE(INFORMATION2) effective_start_date
248: FROM ghr_pa_history -- ghr_assignments_h_v
249: WHERE TABLE_NAME = 'PER_ASSIGNMENTS_F'
250: AND INFORMATION1 = to_Char(p_assignment_id) -- information1 holds assignment_id
251: AND pa_request_id not in
252: (SELECT pa_request_id
253: FROM ghr_pa_history his

Line 337: from per_assignments_f

333: -- Payroll Integration
334: -- Pick BG id
335: Cursor Cur_bg(p_assignment_id NUMBER,p_eff_date DATE) is
336: Select distinct business_group_id bg
337: from per_assignments_f
338: where assignment_id = p_assignment_id
339: and p_eff_date between effective_start_Date
340: and effective_end_date;
341: