APPS.BEN_SUM dependencies on BEN_PLIP_F

Line 90: from ben_plip_f

86: and c_eff_date
87: between pl.effective_start_date and pl.effective_end_date
88: and exists
89: (select null
90: from ben_plip_f
91: where pl_id = pl.pl_id
92: )
93: and pil.per_in_ler_id (+)= pep.per_in_ler_id
94: and ( pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')

Line 128: (select null from ben_plip_f where pl_id = pl.pl_id)

124: between opt.effective_start_date and opt.effective_end_date
125: and c_eff_date
126: between pl.effective_start_date and pl.effective_end_date
127: and exists
128: (select null from ben_plip_f where pl_id = pl.pl_id)
129: and pil.per_in_ler_id (+)= pio.per_in_ler_id
130: and ( pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')
131: or pil.per_in_ler_stat_cd is null )
132: union

Line 155: (select null from ben_plip_f

151: between pep.effective_start_date and pep.effective_end_date
152: and c_eff_date
153: between pl.effective_start_date and pl.effective_end_date
154: and not exists
155: (select null from ben_plip_f
156: where pl_id = pl.pl_id
157: )
158: and pil.per_in_ler_id (+)= pep.per_in_ler_id
159: and ( pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')

Line 193: (select null from ben_plip_f

189: between opt.effective_start_date and opt.effective_end_date
190: and c_eff_date
191: between pl.effective_start_date and pl.effective_end_date
192: and not exists
193: (select null from ben_plip_f
194: where pl_id = pl.pl_id
195: )
196: and pil.per_in_ler_id (+)= pio.per_in_ler_id
197: and ( pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')