APPS.BEN_DELETE_ORPHAN_ROWS dependencies on PER_CONTACT_RELATIONSHIPS

Line 83: delete /*+ parallel(a) */ from per_contact_relationships a

79: --
80: hr_utility.set_location ('Entering ' || l_proc, 5);
81: --
82: --
83: delete /*+ parallel(a) */ from per_contact_relationships a
84: where a.contact_person_id is not null
85: and a.contact_person_id not in ( select /*+ hash_aj index_ffs(ppf) parallel_index(ppf) */ person_id
86: from per_all_people_f ppf );
87: --

Line 88: delete /*+ parallel(a) */ from per_contact_relationships a

84: where a.contact_person_id is not null
85: and a.contact_person_id not in ( select /*+ hash_aj index_ffs(ppf) parallel_index(ppf) */ person_id
86: from per_all_people_f ppf );
87: --
88: delete /*+ parallel(a) */ from per_contact_relationships a
89: where a.person_id is not null
90: and a.person_id not in ( select /*+ hash_aj index_ffs(ppf) parallel_index(ppf) */ person_id
91: from per_all_people_f ppf );
92: --