APPS.HR_ASSIGNMENT_API dependencies on HR_GENERAL

Line 21926: if l_cur_asg.effective_end_date < hr_general.end_of_time then

21922:
21923: end if;
21924: else -- yes current
21925: close csr_get_current_apl_asg;
21926: if l_cur_asg.effective_end_date < hr_general.end_of_time then
21927: --
21928: -- current assignment is end dated
21929: --
21930: if g_debug then

Line 21937: and effective_end_date < hr_general.end_of_time

21933: select max(effective_end_date) into l_mx_end_dated
21934: from per_assignments_f
21935: where person_id = l_assignment.person_id
21936: and assignment_type = 'A'
21937: and effective_end_date < hr_general.end_of_time
21938: and assignment_id <> p_assignment_id;
21939: --
21940: select min(effective_start_date) into l_min_no_end_dated
21941: from per_assignments_f

Line 21944: and effective_end_date = hr_general.end_of_time

21940: select min(effective_start_date) into l_min_no_end_dated
21941: from per_assignments_f
21942: where person_id = l_assignment.person_id
21943: and assignment_type = 'A'
21944: and effective_end_date = hr_general.end_of_time
21945: and assignment_id <> p_assignment_id;
21946: --
21947: if l_mx_end_dated is not null then -- if A
21948: --