DBA Data[Home] [Help]

APPS.HREMPTER dependencies on HR_PERSON_TYPE_USAGE_INFO

Line 3608: SET person_type_id = hr_person_type_usage_info.get_default_person_type_id (l_business_group_id,'EMP')

3604: AND (nvl(fnd_profile.value('HR_ALLOW_FPT_UPDATES'),'N') = 'Y') THEN
3605:
3606: -- Updating the per table to EMP or EMP_APL according to existing data.
3607: UPDATE per_all_people_f
3608: SET person_type_id = hr_person_type_usage_info.get_default_person_type_id (l_business_group_id,'EMP')
3609: ,current_emp_or_apl_flag = 'Y'
3610: ,current_employee_flag = 'Y'
3611: WHERE person_id = p_person_id
3612: AND person_type_id = hr_person_type_usage_info.get_default_person_type_id (l_business_group_id,'EX_EMP')

Line 3612: AND person_type_id = hr_person_type_usage_info.get_default_person_type_id (l_business_group_id,'EX_EMP')

3608: SET person_type_id = hr_person_type_usage_info.get_default_person_type_id (l_business_group_id,'EMP')
3609: ,current_emp_or_apl_flag = 'Y'
3610: ,current_employee_flag = 'Y'
3611: WHERE person_id = p_person_id
3612: AND person_type_id = hr_person_type_usage_info.get_default_person_type_id (l_business_group_id,'EX_EMP')
3613: AND effective_start_date >= p_actual_termination_date;
3614:
3615: UPDATE per_all_people_f
3616: SET person_type_id = hr_person_type_usage_info.get_default_person_type_id (l_business_group_id,'EMP_APL')

Line 3616: SET person_type_id = hr_person_type_usage_info.get_default_person_type_id (l_business_group_id,'EMP_APL')

3612: AND person_type_id = hr_person_type_usage_info.get_default_person_type_id (l_business_group_id,'EX_EMP')
3613: AND effective_start_date >= p_actual_termination_date;
3614:
3615: UPDATE per_all_people_f
3616: SET person_type_id = hr_person_type_usage_info.get_default_person_type_id (l_business_group_id,'EMP_APL')
3617: ,current_emp_or_apl_flag = 'Y'
3618: ,current_employee_flag = 'Y'
3619: WHERE person_id = p_person_id
3620: AND person_type_id = hr_person_type_usage_info.get_default_person_type_id (l_business_group_id,'EX_EMP_APL')

Line 3620: AND person_type_id = hr_person_type_usage_info.get_default_person_type_id (l_business_group_id,'EX_EMP_APL')

3616: SET person_type_id = hr_person_type_usage_info.get_default_person_type_id (l_business_group_id,'EMP_APL')
3617: ,current_emp_or_apl_flag = 'Y'
3618: ,current_employee_flag = 'Y'
3619: WHERE person_id = p_person_id
3620: AND person_type_id = hr_person_type_usage_info.get_default_person_type_id (l_business_group_id,'EX_EMP_APL')
3621: AND effective_start_date >= p_actual_termination_date;
3622:
3623: ELSE
3624: -- Changes start for the bug 13571033

Line 3636: PERSON_TYPE_ID = hr_person_type_usage_info.get_default_person_type_id(l_business_group_id,'EMP')

3632: --
3633: UPDATE per_all_people_f pp
3634: SET CURRENT_EMP_OR_APL_FLAG = 'Y',
3635: CURRENT_EMPLOYEE_FLAG = 'Y',
3636: PERSON_TYPE_ID = hr_person_type_usage_info.get_default_person_type_id(l_business_group_id,'EMP')
3637: WHERE pp.person_id = p_person_id
3638: AND pp.effective_start_date = p_actual_termination_date+1;
3639: else
3640: --