APPS.BEN_CON_LER dependencies on PER_ALL_PEOPLE_F

Line 115: from per_all_people_f

111: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt;
112:
113: cursor get_person_date(p_person_id in number) is
114: select min(effective_start_date) -- 3518038
115: from per_all_people_f
116: where person_id = p_person_id
117: and business_group_id = p_new.business_group_id;
118: --Bug 2206932 (always using the system date as user can start relationship before
119: --before the person is started.

Line 165: cursor c_per_type (p_person_id in per_all_people_f.person_id%TYPE )is

161: l_flag boolean:=FALSE;
162: l_initial_date DATE;
163: l_ler_eff_strt_dt DATE;
164: --
165: cursor c_per_type (p_person_id in per_all_people_f.person_id%TYPE )is
166: select con.system_person_type
167: from per_all_people_f per , per_person_types con
168: where per.person_id = p_person_id
169: and per.person_type_id = con.person_type_id

Line 167: from per_all_people_f per , per_person_types con

163: l_ler_eff_strt_dt DATE;
164: --
165: cursor c_per_type (p_person_id in per_all_people_f.person_id%TYPE )is
166: select con.system_person_type
167: from per_all_people_f per , per_person_types con
168: where per.person_id = p_person_id
169: and per.person_type_id = con.person_type_id
170: and l_session_date between per.effective_start_date and per.effective_end_date ;
171: --