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.GHR_CREATE_PTNL_LIFE_EVENTS dependencies on PER_PERSON_TYPES

Line 115: from per_all_people_f , per_person_types

111: IN ('HEALTH BENEFITS','HEALTH BENEFITS PRE TAX') ;
112:
113: Cursor c_chk_emp_exemp is
114: select 1
115: from per_all_people_f , per_person_types
116: where person_id = p_pa_request_rec.person_id
117: and trunc (p_pa_request_rec.effective_date - 1) between
118: effective_start_date and effective_end_date
119: and per_all_people_f.business_group_id = per_person_types.business_group_id

Line 119: and per_all_people_f.business_group_id = per_person_types.business_group_id

115: from per_all_people_f , per_person_types
116: where person_id = p_pa_request_rec.person_id
117: and trunc (p_pa_request_rec.effective_date - 1) between
118: effective_start_date and effective_end_date
119: and per_all_people_f.business_group_id = per_person_types.business_group_id
120: and per_all_people_f.person_type_id = per_person_types.person_type_id
121: and system_person_type = 'EX_EMP';
122:
123: Cursor c_chk_separated is

Line 120: and per_all_people_f.person_type_id = per_person_types.person_type_id

116: where person_id = p_pa_request_rec.person_id
117: and trunc (p_pa_request_rec.effective_date - 1) between
118: effective_start_date and effective_end_date
119: and per_all_people_f.business_group_id = per_person_types.business_group_id
120: and per_all_people_f.person_type_id = per_person_types.person_type_id
121: and system_person_type = 'EX_EMP';
122:
123: Cursor c_chk_separated is
124: select 1