APPS.HR_MASS_MOVE_API dependencies on PER_ASSIGNMENTS_F

Line 221: from per_assignments_f asg1

217: --
218: cursor csr_get_old_asg_data is
219: select asg1.effective_start_date
220: , asg1.object_version_number
221: from per_assignments_f asg1
222: where asg1.assignment_id = p_assignment_id
223: and asg1.effective_start_date =
224: (select max(asg2.effective_start_date)
225: from per_assignments_f asg2

Line 225: from per_assignments_f asg2

221: from per_assignments_f asg1
222: where asg1.assignment_id = p_assignment_id
223: and asg1.effective_start_date =
224: (select max(asg2.effective_start_date)
225: from per_assignments_f asg2
226: where asg1.assignment_id = asg2.assignment_id
227: and asg2.effective_start_date < p_effective_date);
228: --
229: begin

Line 2008: from per_assignments_f asg,

2004: l_tax_district_changed_warning BOOLEAN;
2005: --
2006: cursor csr_future_asg_changes is
2007: select null
2008: from per_assignments_f asg,
2009: per_mass_moves mm,
2010: per_mm_assignments mmasg
2011: where mmasg.assignment_id = l_mm_assignment_id
2012: and asg.assignment_id = mmasg.assignment_id

Line 2035: per_assignments_f asg,

2031: per.full_name,
2032: org.name orgname,
2033: neworg.name neworgname
2034: from per_mm_assignments mm_asg,
2035: per_assignments_f asg,
2036: per_people_f per,
2037: per_organization_units org,
2038: per_mass_moves mm,
2039: per_organization_units neworg