eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_CON_LER dependencies on PER_PERSON_TYPES

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: --

Line 172: l_per_type per_person_types.system_person_type%TYPE ;

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: --
172: l_per_type per_person_types.system_person_type%TYPE ;
173: l_con_per_type per_person_types.system_person_type%TYPE ;
174: --
175:
176: begin

Line 173: l_con_per_type per_person_types.system_person_type%TYPE ;

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: --
172: l_per_type per_person_types.system_person_type%TYPE ;
173: l_con_per_type per_person_types.system_person_type%TYPE ;
174: --
175:
176: begin
177: --