APPS.BEN_DM_DELETE dependencies on BEN_PER_IN_LER

Line 105: where per_in_ler_id in (select per_in_ler_id from ben_per_in_ler

101:
102: hr_general.g_data_migrator_mode := 'Y';
103:
104: delete from ben_le_clsn_n_rstr
105: where per_in_ler_id in (select per_in_ler_id from ben_per_in_ler
106: where person_id =p_person_id);
107:
108: delete from ben_per_bnfts_bal_f where person_id = p_person_id;
109:

Line 132: where per_in_ler_id in (select per_in_ler_id from ben_per_in_ler

128:
129: delete from ben_enrt_rt
130: where elig_per_elctbl_chc_id in
131: (select elig_per_elctbl_chc_id from ben_elig_per_elctbl_chc
132: where per_in_ler_id in (select per_in_ler_id from ben_per_in_ler
133: where person_id =p_person_id));
134:
135: delete from ben_enrt_prem
136: where elig_per_elctbl_chc_id in

Line 138: where per_in_ler_id in (select per_in_ler_id from ben_per_in_ler

134:
135: delete from ben_enrt_prem
136: where elig_per_elctbl_chc_id in
137: (select elig_per_elctbl_chc_id from ben_elig_per_elctbl_chc
138: where per_in_ler_id in (select per_in_ler_id from ben_per_in_ler
139: where person_id =p_person_id));
140:
141: delete from ben_enrt_rt
142: where enrt_bnft_id in

Line 146: where per_in_ler_id in (select per_in_ler_id from ben_per_in_ler

142: where enrt_bnft_id in
143: (select enrt_bnft_id from ben_enrt_bnft
144: where elig_per_elctbl_chc_id in
145: (select elig_per_elctbl_chc_id from ben_elig_per_elctbl_chc
146: where per_in_ler_id in (select per_in_ler_id from ben_per_in_ler
147: where person_id =p_person_id)));
148:
149: delete from BEN_ELCTBL_CHC_CTFN
150: where elig_per_elctbl_chc_id in

Line 152: where per_in_ler_id in (select per_in_ler_id from ben_per_in_ler

148:
149: delete from BEN_ELCTBL_CHC_CTFN
150: where elig_per_elctbl_chc_id in
151: (select elig_per_elctbl_chc_id from ben_elig_per_elctbl_chc
152: where per_in_ler_id in (select per_in_ler_id from ben_per_in_ler
153: where person_id =p_person_id));
154:
155: delete from BEN_ELCTBL_CHC_CTFN
156: where enrt_bnft_id in

Line 160: where per_in_ler_id in (select per_in_ler_id from ben_per_in_ler

156: where enrt_bnft_id in
157: (select enrt_bnft_id from ben_enrt_bnft
158: where elig_per_elctbl_chc_id in
159: (select elig_per_elctbl_chc_id from ben_elig_per_elctbl_chc
160: where per_in_ler_id in (select per_in_ler_id from ben_per_in_ler
161: where person_id =p_person_id)));
162:
163: delete from ben_enrt_bnft
164: where elig_per_elctbl_chc_id in

Line 166: where per_in_ler_id in (select per_in_ler_id from ben_per_in_ler

162:
163: delete from ben_enrt_bnft
164: where elig_per_elctbl_chc_id in
165: (select elig_per_elctbl_chc_id from ben_elig_per_elctbl_chc
166: where per_in_ler_id in (select per_in_ler_id from ben_per_in_ler
167: where person_id =p_person_id));
168:
169: delete from ben_elig_per_elctbl_chc
170: where per_in_ler_id in (select per_in_ler_id from ben_per_in_ler

Line 170: where per_in_ler_id in (select per_in_ler_id from ben_per_in_ler

166: where per_in_ler_id in (select per_in_ler_id from ben_per_in_ler
167: where person_id =p_person_id));
168:
169: delete from ben_elig_per_elctbl_chc
170: where per_in_ler_id in (select per_in_ler_id from ben_per_in_ler
171: where person_id =p_person_id);
172:
173: delete from ben_pil_elctbl_chc_popl
174: where per_in_ler_id in (select per_in_ler_id from ben_per_in_ler

Line 174: where per_in_ler_id in (select per_in_ler_id from ben_per_in_ler

170: where per_in_ler_id in (select per_in_ler_id from ben_per_in_ler
171: where person_id =p_person_id);
172:
173: delete from ben_pil_elctbl_chc_popl
174: where per_in_ler_id in (select per_in_ler_id from ben_per_in_ler
175: where person_id =p_person_id);
176:
177: delete from PAY_ELEMENT_ENTRY_VALUES_F
178: where element_entry_id

Line 223: (select per_in_ler_id from ben_per_in_ler where person_id =p_person_id);

219: delete from ben_elig_cvrd_dpnt_f where prtt_enrt_rslt_id in
220: (select prtt_enrt_rslt_id from ben_prtt_enrt_rslt_f where person_id =p_person_id);
221:
222: delete from ben_elig_dpnt where per_in_ler_id in
223: (select per_in_ler_id from ben_per_in_ler where person_id =p_person_id);
224:
225: delete from ben_pl_bnf_ctfn_prvdd_f where pl_bnf_id in
226: (select pl_bnf_id from ben_pl_bnf_f where prtt_enrt_rslt_id in
227: (select prtt_enrt_rslt_id from ben_prtt_enrt_rslt_f where person_id =p_person_id));

Line 245: delete from ben_per_in_ler where person_id =p_person_id;

241: (select per_cm_id from ben_per_cm_f where person_id =p_person_id);
242:
243: delete from ben_per_cm_f where person_id =p_person_id;
244:
245: delete from ben_per_in_ler where person_id =p_person_id;
246:
247: delete from ben_ptnl_ler_for_per where person_id =p_person_id;
248:
249: delete from ben_elig_per_opt_f where elig_per_id in