APPS.HR_APPLICANT_INTERNAL dependencies on PER_ALL_ASSIGNMENTS_F

Line 1673: UPDATE per_all_assignments_f

1669: hr_utility.trace('Update APL asg belonging to future applications');
1670: hr_utility.trace('OLD appl id = '||p_old_application_id);
1671: hr_utility.trace('New appl id = '||p_new_application_id);
1672:
1673: UPDATE per_all_assignments_f
1674: set application_id = p_new_application_id
1675: where business_group_id = p_business_group_id
1676: and application_id is not null
1677: and application_id = p_old_application_id;

Line 2013: from per_all_assignments_f paf

2009: ) RETURN VARCHAR2 IS
2010: --
2011: cursor csr_future_apl_asg is
2012: select 'Y'
2013: from per_all_assignments_f paf
2014: where paf.person_id = p_person_id
2015: and paf.effective_start_date > p_effective_date
2016: and paf.assignment_type = 'A'
2017: and paf.application_id = p_application_id;