APPS.HR_UTIL_MISC_SS dependencies on PER_ASSIGNMENTS_F

Line 513: FROM per_assignments_f2 paf, per_assignment_status_types past

509:
510:
511: cursor fetch_asg (l_person_id NUMBER, l_effective_date DATE) is
512: SELECT 'T'
513: FROM per_assignments_f2 paf, per_assignment_status_types past
514: WHERE paf.person_id = l_person_id
515: AND l_effective_date between paf.effective_start_date and paf.effective_end_date
516: AND paf.primary_flag = 'Y'
517: AND paf.assignment_type IN ('E', 'C')

Line 1125: from per_people_f ppf, per_assignments_f paf

1121: hr_utility.set_location('Entering: '|| l_proc,5);
1122:
1123: select assignment_id
1124: into assi_id
1125: from per_people_f ppf, per_assignments_f paf
1126: where paf.person_id = ppf.person_id
1127: and trunc(sysdate) between paf.effective_start_date(+) and paf.effective_end_date(+)
1128: and trunc(sysdate) between ppf.effective_start_date(+) and ppf.effective_end_date(+)
1129: and ppf.person_id = p_person_id