APPS.HR_APPLICANT_INTERNAL dependencies on PER_ALL_ASSIGNMENTS_F

Line 1833: UPDATE per_all_assignments_f

1829: hr_utility.trace('Update APL asg belonging to future applications');
1830: hr_utility.trace('OLD appl id = '||p_old_application_id);
1831: hr_utility.trace('New appl id = '||p_new_application_id);
1832:
1833: UPDATE per_all_assignments_f
1834: set application_id = p_new_application_id
1835: where business_group_id = p_business_group_id
1836: and application_id is not null
1837: and application_id = p_old_application_id;

Line 2224: from per_all_assignments_f paf

2220: --
2221: -- ER FPT
2222: cursor csr_future_apl_asg is
2223: select 'Y'
2224: from per_all_assignments_f paf
2225: where paf.person_id = p_person_id
2226: and paf.effective_start_date > p_effective_date
2227: and paf.assignment_type = 'A'
2228: and paf.application_id = p_application_id

Line 2231: FROM per_all_assignments_f asg

2227: and paf.assignment_type = 'A'
2228: and paf.application_id = p_application_id
2229: and paf.assignment_id IN
2230: (SELECT assignment_id
2231: FROM per_all_assignments_f asg
2232: WHERE asg.person_id = p_person_id
2233: AND asg.application_id = p_application_id
2234: AND p_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date);
2235: --