APPS.HR_ASSIGNMENT_API dependencies on HR_GENERAL

Line 22480: and (apl.effective_end_date = hr_general.end_of_time

22476: select 'Y' from per_assignments_f apl
22477: where apl.assignment_type = 'A'
22478: and apl.application_id = cp_appl_id
22479: and apl.assignment_id <> cp_asg_id
22480: and (apl.effective_end_date = hr_general.end_of_time
22481: or exists
22482: (select 'Y' from per_applications apa
22483: where apa.application_id = cp_appl_id
22484: and apa.date_end is not null

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

22949:
22950: end if;
22951: else -- yes current
22952: close csr_get_current_apl_asg;
22953: if l_cur_asg.effective_end_date < hr_general.end_of_time then
22954: --
22955: -- current assignment is end dated
22956: --
22957: if g_debug then

Line 22964: and effective_end_date < hr_general.end_of_time

22960: select max(effective_end_date) into l_mx_end_dated
22961: from per_assignments_f
22962: where person_id = l_assignment.person_id
22963: and assignment_type = 'A'
22964: and effective_end_date < hr_general.end_of_time
22965: and assignment_id <> p_assignment_id;
22966: --
22967: select min(effective_start_date) into l_min_no_end_dated
22968: from per_assignments_f

Line 22971: and effective_end_date = hr_general.end_of_time

22967: select min(effective_start_date) into l_min_no_end_dated
22968: from per_assignments_f
22969: where person_id = l_assignment.person_id
22970: and assignment_type = 'A'
22971: and effective_end_date = hr_general.end_of_time
22972: and assignment_id <> p_assignment_id;
22973:
22974: hr_utility.set_location('l_mx_end_dated:'||l_mx_end_dated,72);
22975: hr_utility.set_location('l_min_no_end_dated:'||l_min_no_end_dated,73);