APPS.BEN_EGD_LER dependencies on PER_ALL_PEOPLE_F

Line 99: p_person_id IN per_all_people_f.person_id%TYPE,

95: AND source_table = 'BEN_ELIG_DPNT'
96: order by 1;
97: --
98: CURSOR le_exists(
99: p_person_id IN per_all_people_f.person_id%TYPE,
100: p_ler_id IN ben_ler_f.ler_id%TYPE,
101: p_lf_evt_ocrd_dt IN DATE) IS
102: SELECT 'Y'
103: FROM ben_ptnl_ler_for_per bp

Line 109: CURSOR get_contacts(p_person_id IN per_all_people_f.person_id%TYPE) IS

105: AND bp.ler_id = p_ler_id
106: AND bp.ptnl_ler_for_per_stat_cd = 'DTCTD'
107: AND bp.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt;
108: --
109: CURSOR get_contacts(p_person_id IN per_all_people_f.person_id%TYPE) IS
110: SELECT pcr.contact_person_id
111: FROM per_contact_relationships pcr
112: WHERE pcr.person_id = p_person_id
113: AND pcr.business_group_id = p_new.business_group_id;/*

Line 163: l_rec_dpnt_person_id per_all_people_f.person_id%TYPE

159: --
160: --
161: l_rec_business_group_id ben_ler_f.business_group_id%TYPE
162: := NVL(p_new.business_group_id, p_old.business_group_id);
163: l_rec_dpnt_person_id per_all_people_f.person_id%TYPE
164: := NVL(p_new.dpnt_person_id, p_old.dpnt_person_id);
165:
166:
167: /*Bug 9500422: Add the dpnt_person_id to the list if there is a change in BEN_ELIG_DPNT data of a dependent.