APPS.PER_PQH_SHR dependencies on HR_GENERAL

Line 33: and nvl(ver.date_to, hr_general.end_of_time);

29: ver.organization_structure_id = str.organization_structure_id
30: and str.business_group_id = p_business_group_id
31: and str.position_control_structure_flg='Y'
32: and nvl(p_effective_date, sysdate) between ver.date_from
33: and nvl(ver.date_to, hr_general.end_of_time);
34: --
35: --
36: cursor c_assignment(p_assignment_id number, p_effective_date date) is
37: select organization_id, business_group_id

Line 610: p_start_date => hr_general.end_of_time,

606: WF_LOCAL_SYNCH.propagate_user_role(p_user_orig_system => 'PER',
607: p_user_orig_system_id => p_rec.person_id,
608: p_role_orig_system => 'POS',
609: p_role_orig_system_id => l_old_pos_id,
610: p_start_date => hr_general.end_of_time,
611: p_expiration_date => hr_general.end_of_time);
612: else
613: open get_eff_st_date(l_old_pos_id);
614: fetch get_eff_st_date into l_effective_start_date;

Line 611: p_expiration_date => hr_general.end_of_time);

607: p_user_orig_system_id => p_rec.person_id,
608: p_role_orig_system => 'POS',
609: p_role_orig_system_id => l_old_pos_id,
610: p_start_date => hr_general.end_of_time,
611: p_expiration_date => hr_general.end_of_time);
612: else
613: open get_eff_st_date(l_old_pos_id);
614: fetch get_eff_st_date into l_effective_start_date;
615: close get_eff_st_date;