APPS.PER_HRTCA_MERGE dependencies on PER_ALL_ASSIGNMENTS_F

Line 78: from per_all_assignments_f

74: cursor c_events is
75: select /*+ INDEX(per_events) */ *
76: from per_events
77: where assignment_id in (select assignment_id
78: from per_all_assignments_f
79: where person_id = p_rec.person_id);
80: --
81: l_events c_events%rowtype;
82: --

Line 1682: type assignmentid is table of per_all_assignments_f.assignment_id%type index by binary_integer;

1678: --
1679: l_proc varchar2(80) := g_package||'set_party_in_hrms';
1680: -- Bug fix 3632535 starts here
1681:
1682: type assignmentid is table of per_all_assignments_f.assignment_id%type index by binary_integer;
1683: l_assignment_id assignmentid;
1684:
1685: -- Bug fix 3632535 ends here
1686:

Line 1736: from per_all_assignments_f

1732: -- improve performance.
1733:
1734: select assignment_id
1735: bulk collect into l_assignment_id
1736: from per_all_assignments_f
1737: where person_id = p_person_id;
1738:
1739: forall i in 1..l_assignment_id.count
1740: update PER_EVENTS

Line 1749: from per_all_assignments_f

1745:
1746: /*update PER_EVENTS
1747: set party_id = p_party_id
1748: where assignment_id in (select assignment_id
1749: from per_all_assignments_f
1750: where person_id = p_person_id);*/
1751: exception
1752: when no_data_found then
1753: null;

Line 6195: from per_all_assignments_f

6191: update per_events
6192: set party_id = t_party_id(i)
6193: where assignment_id in
6194: (select assignment_id
6195: from per_all_assignments_f
6196: where person_id = t_elig_person_id(i));
6197: --
6198: -- Bulk update address records
6199: --