APPS.PER_PDS_UTILS dependencies on BEN_PER_IN_LER

Line 49: from ben_per_in_ler pil

45: /*Cursors for BEN validations*/
46: cursor procd_le_exists(p_person_id in number
47: ,p_effective_date in date) is
48: select 'Y'
49: from ben_per_in_ler pil
50: where pil.person_id = p_person_id
51: and pil.per_in_ler_stat_cd in ('STRTD','PROCD')
52: and pil.lf_evt_ocrd_dt < p_effective_date;
53: --

Line 58: from ben_per_in_ler pil

54: cursor procd_le_exists_fpd(p_person_id in number
55: ,p_effective_date in date
56: ,p_max_fpd in date) is
57: select 'Y'
58: from ben_per_in_ler pil
59: where pil.person_id = p_person_id
60: and pil.per_in_ler_stat_cd in ('STRTD','PROCD')
61: and pil.lf_evt_ocrd_dt < p_effective_date
62: and pil.lf_evt_ocrd_dt > p_max_fpd;