APPS.HR_ASSIGNMENT_API dependencies on PER_ASSIGNMENTS_F

Line 22476: select 'Y' from per_assignments_f apl

22472: and paaf1.assignment_id = paaf.assignment_id
22473: and paaf1.assignment_type = 'E' );
22474:
22475: cursor csr_other_asgs(cp_asg_id number, cp_appl_id number) is
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

Line 22961: from per_assignments_f

22957: if g_debug then
22958: hr_utility.set_location(l_proc,100);
22959: end if;
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;

Line 22968: from per_assignments_f

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
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;