APPS.BEN_CWB_MASS_NOTIFN_PKG dependencies on BEN_CWB_PERSON_TASKS

Line 197: from ben_cwb_person_tasks tsk

193: OR
194: ((v_target_pop = 'MWT')
195: AND (hrchy.lvl_num = 0)
196: AND NOT EXISTS (select tsk.task_id
197: from ben_cwb_person_tasks tsk
198: where tsk.group_per_in_ler_id = hrchy.mgr_per_in_ler_id
199: and tsk.status_cd in ('IP','NA','CO'))
200: )
201: )