DBA Data[Home] [Help]

APPS.BEN_CWB_MASS_NOTIFN_PKG dependencies on PER_ASSIGNMENTS_F

Line 51: , per_assignments_f paf

47: ,null
48: ,ppf.business_group_id
49: FROM per_all_people_f ppf
50: , per_person_types ppt
51: , per_assignments_f paf
52: , per_business_groups_perf bg
53: WHERE ppf.person_id=paf.person_id
54: AND sysdate BETWEEN ppf.effective_start_date AND ppf.effective_end_date
55: AND paf.primary_flag = 'Y'

Line 288: ,per_assignments_f paf

284: )
285: IS
286: SELECT info.assignment_id
287: FROM ben_cwb_person_info info
288: ,per_assignments_f paf
289: WHERE info.group_per_in_ler_id = v_group_per_in_ler_id
290: AND paf.assignment_id = info.assignment_id
291: AND sysdate BETWEEN paf.effective_start_date AND paf.effective_end_date;
292: