APPS.BEN_DELETE_ORPHAN_ROWS dependencies on BEN_ELIG_DPNT

Line 190: -- This is procedure to delete orphan records from BEN_ELIG_DPNT

186: -- ----------------------------------------------------------------------------
187: -- |-------------------------< delete_elig_dpnt >--------------------------|
188: -- ----------------------------------------------------------------------------
189: --
190: -- This is procedure to delete orphan records from BEN_ELIG_DPNT
191: -- where deleted person_id is directly referenced.
192: --
193: procedure delete_elig_dpnt
194: is

Line 204: DELETE /*+ PARALLEL(A) */ FROM ben_elig_dpnt a

200: --
201: hr_utility.set_location ('Entering ' || l_proc, 5);
202: --
203: --
204: DELETE /*+ PARALLEL(A) */ FROM ben_elig_dpnt a
205: WHERE a.dpnt_person_id IS NOT NULL
206: AND a.dpnt_person_id NOT IN (SELECT /*+ HASH_AJ INDEX_FFS(PER) PARALLEL_INDEX(PER) */ person_id
207: FROM per_all_people_f per);
208: ben_batch_utils.write(p_text => 'BEN_ELIG_DPNT : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

Line 208: ben_batch_utils.write(p_text => 'BEN_ELIG_DPNT : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

204: DELETE /*+ PARALLEL(A) */ FROM ben_elig_dpnt a
205: WHERE a.dpnt_person_id IS NOT NULL
206: AND a.dpnt_person_id NOT IN (SELECT /*+ HASH_AJ INDEX_FFS(PER) PARALLEL_INDEX(PER) */ person_id
207: FROM per_all_people_f per);
208: ben_batch_utils.write(p_text => 'BEN_ELIG_DPNT : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
209: --
210: hr_utility.set_location ('Leaving ' || l_proc, 10);
211: --
212: end delete_elig_dpnt;

Line 697: -- BEN_ELIG_DPNT

693: -- BEN_PER_IN_LER
694: -- BEN_BNFT_PRVDD_LDGR_F
695: -- BEN_CBR_PER_IN_LER
696: -- BEN_ELIG_PER_OPT_F
697: -- BEN_ELIG_DPNT
698: -- BEN_PIL_ELCTBL_CHC_POPL
699: -- BEN_PRTT_PREM_BY_MO_F
700: -- BEN_PRTT_PREM_F
701: -- BEN_ENRT_PREM

Line 748: delete from BEN_ELIG_DPNT a

744: --
745: ben_batch_utils.write(p_text => 'BEN_ELIG_PER_OPT_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
746: --
747: FORALL i IN 1..l_data.COUNT
748: delete from BEN_ELIG_DPNT a
749: where PER_IN_LER_ID = l_data(i);
750: --
751: ben_batch_utils.write(p_text => 'BEN_ELIG_DPNT : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
752: --

Line 751: ben_batch_utils.write(p_text => 'BEN_ELIG_DPNT : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

747: FORALL i IN 1..l_data.COUNT
748: delete from BEN_ELIG_DPNT a
749: where PER_IN_LER_ID = l_data(i);
750: --
751: ben_batch_utils.write(p_text => 'BEN_ELIG_DPNT : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
752: --
753: FORALL i IN 1..l_data.COUNT
754: delete from BEN_PIL_ELCTBL_CHC_POPL a
755: where PER_IN_LER_ID = l_data(i);