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 1685: type assignmentid is table of per_all_assignments_f.assignment_id%type index by binary_integer;

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

Line 1739: from per_all_assignments_f

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

Line 1752: from per_all_assignments_f

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

Line 6215: from per_all_assignments_f

6211: update per_events
6212: set party_id = t_party_id(i)
6213: where assignment_id in
6214: (select assignment_id
6215: from per_all_assignments_f
6216: where person_id = t_elig_person_id(i));
6217: --
6218: -- Bulk update address records
6219: --