4418: is
4419: l_ret Number;
4420: begin
4421: if
4422: hr_person_type_usage_info.is_person_of_type(p_effective_date,p_person_id,'EMP')
4423: or
4424: hr_person_type_usage_info.is_person_of_type(p_effective_date,p_person_id,'EMP_APL')
4425: or
4426: hr_person_type_usage_info.is_person_of_type(p_effective_date,p_person_id,'EX_EMP')
4420: begin
4421: if
4422: hr_person_type_usage_info.is_person_of_type(p_effective_date,p_person_id,'EMP')
4423: or
4424: hr_person_type_usage_info.is_person_of_type(p_effective_date,p_person_id,'EMP_APL')
4425: or
4426: hr_person_type_usage_info.is_person_of_type(p_effective_date,p_person_id,'EX_EMP')
4427: or
4428: hr_person_type_usage_info.is_person_of_type(p_effective_date,p_person_id,'EX_EMP_APL')
4422: hr_person_type_usage_info.is_person_of_type(p_effective_date,p_person_id,'EMP')
4423: or
4424: hr_person_type_usage_info.is_person_of_type(p_effective_date,p_person_id,'EMP_APL')
4425: or
4426: hr_person_type_usage_info.is_person_of_type(p_effective_date,p_person_id,'EX_EMP')
4427: or
4428: hr_person_type_usage_info.is_person_of_type(p_effective_date,p_person_id,'EX_EMP_APL')
4429: then
4430: l_ret := 1;
4424: hr_person_type_usage_info.is_person_of_type(p_effective_date,p_person_id,'EMP_APL')
4425: or
4426: hr_person_type_usage_info.is_person_of_type(p_effective_date,p_person_id,'EX_EMP')
4427: or
4428: hr_person_type_usage_info.is_person_of_type(p_effective_date,p_person_id,'EX_EMP_APL')
4429: then
4430: l_ret := 1;
4431: else
4432: l_ret := 0;