APPS.GHR_GHRWS52L dependencies on PER_ASSIGNMENTS_F

Line 244: WHERE TABLE_NAME = 'PER_ASSIGNMENTS_F'

240:
241: CURSOR c_prior_ds_date (p_assignment_id in number) is
242: SELECT FND_DATE.CANONICAL_TO_DATE(INFORMATION2) effective_start_date
243: FROM ghr_pa_history -- ghr_assignments_h_v
244: WHERE TABLE_NAME = 'PER_ASSIGNMENTS_F'
245: AND INFORMATION1 = to_Char(p_assignment_id) -- information1 holds assignment_id
246: AND pa_request_id not in
247: (SELECT pa_request_id
248: FROM ghr_pa_history his

Line 332: from per_assignments_f

328: -- Payroll Integration
329: -- Pick BG id
330: Cursor Cur_bg(p_assignment_id NUMBER,p_eff_date DATE) is
331: Select distinct business_group_id bg
332: from per_assignments_f
333: where assignment_id = p_assignment_id
334: and p_eff_date between effective_start_Date
335: and effective_end_date;
336: