APPS.BEN_ECL_BUS dependencies on BEN_ELIG_PER_TYP_PRTE_F

Line 223: from ben_elig_per_typ_prte_f b

219: --
220: /* --
221: cursor c1 is
222: select null
223: from ben_elig_per_typ_prte_f b
224: where b.eligy_prfl_id = p_eligy_prfl_id
225: and b.per_typ_cd NOT IN ('EMP', 'EMP_APL')
226: and b.excld_flag = 'N';
227: -- */

Line 231: from ben_elig_per_typ_prte_f b ,

227: -- */
228: --
229: cursor c1 is
230: select null
231: from ben_elig_per_typ_prte_f b ,
232: per_person_types ppt
233: where b.eligy_prfl_id = p_eligy_prfl_id
234: and b.person_type_id =ppt.person_type_id
235: and ppt.system_person_type NOT IN ('EMP', 'EMP_APL')