573: per_people_pkg.insert_row(
574: p_rowid => p_rowid,
575: p_person_id => p_person_id ,
576: p_effective_start_date => p_effective_start_date + 1,
577: p_effective_end_date => hr_general.end_of_time,
578: p_business_group_id => p_business_group_id ,
579: p_person_type_id => p_person_type_id ,
580: p_last_name => p_last_name,
581: p_start_date => p_date_received,
796: ,p_add_information18 => p_add_information18
797: ,p_add_information19 => p_add_information19
798: ,p_add_information20 => p_add_information20
799: -- ***** End new code for bug 2711964 ***************
800: ,p_end_of_time => hr_general.end_of_time
801: );
802: end if ;
803: --
804: --
863: --
864: if ( p_per_system_status = 'TERM_APL' ) then
865: l_asg_end_date := p_date_received ;
866: else
867: l_asg_end_date := hr_general.end_of_time ;
868: end if ;
869: --
870: --
871: -- Get the working conditions.
1364: from fnd_descr_flex_contexts_vl
1365: where (descriptive_flex_context_code = p_legislation_code
1366: or (p_legislation_code = descriptive_flex_context_code
1367: and p_legislation_code in ('CA','US')
1368: and hr_general.chk_geocodes_installed = 'Y'))
1369: and descriptive_flexfield_name = 'Address Structure'
1370: and application_id = 800 -- Bug fix 3648715
1371: and enabled_flag = 'Y';
1372: --