[Home] [Help]
3139: l_person_id per_people_f.person_id%type;
3140: l_person_type_id per_people_f.person_type_id%type;
3141: l_date1 ghr_pa_requests.effective_date%type;
3142: l_address_id per_addresses.address_id%type;
3143: l_person_type per_person_types.system_person_type%type;
3144: --l_sec_assignmemt_id per_assignments_f.assignment_id%type;
3145: --l_assignment_status_type_id per_assignment_status_types.assignment_status_type_id%type;
3146: --
3147: l_asg_trm_eff_start_date per_assignments_f.effective_start_date%type;
3267:
3268: cursor c_person_type is
3269: Select ppt.system_person_type,
3270: ppf.person_type_id
3271: from per_person_types ppt,
3272: per_all_people_f ppf
3273: where ppf.person_id = P_pa_request_rec.person_id
3274: and ppt.person_type_id = ppf.person_type_id
3275: and g_effective_date between ppf.effective_start_date
3291: -- EX_Employee person type
3292:
3293: Cursor c_ex_emp_per_type is
3294: select ppt.person_type_id
3295: from per_person_types ppt
3296: where ppt.business_group_id = l_business_group_id
3297: and ppt.system_person_type = 'EX_EMP'
3298: -- and ppt.user_person_type = 'Ex-employee'
3299: and ppt.active_flag = 'Y'
5186: l_dt_mode varchar2(200);
5187:
5188: cursor cur_ex_emp (p_person_id IN Number, p_effective_date IN Date) is
5189: select 1
5190: from per_person_types pet,
5191: per_people_f per
5192: where pet.person_type_id = per.person_type_id
5193: and per.person_id = p_person_id
5194: and p_effective_date