DBA Data[Home] [Help]

APPS.BEN_ECL_BUS dependencies on PER_PERSON_TYPES

Line 232: per_person_types ppt

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')
236: and b.excld_flag = 'N';