APPS.BEN_SEED_LIFE_EVENTS dependencies on BEN_STARTUP_LERS

Line 84: from ben_startup_lers s_ler

80: 'N',
81: decode(TYP_CD,'DRVDAGE','PRCM', 'DRVDCAL','PRCM','DRVDCMP','PRCM','DRVDHRW','PRCM','DRVDLOS','PRCM',NULL) ,
82: decode(TYP_CD,'DRVDAGE',90, 'DRVDCAL',90,'DRVDCMP',90,'DRVDHRW',90,'DRVDLOS',90,NULL) ,
83: 1
84: from ben_startup_lers s_ler
85: where not exists (select 1
86: from ben_ler_f ler
87: where s_ler.typ_cd = ler.typ_cd
88: and ler.business_group_id = p_business_group_id

Line 123: ,ben_startup_lers_tl tl

119: b.last_update_login,
120: b.created_by,
121: b.creation_date
122: from ben_ler_f b
123: ,ben_startup_lers_tl tl
124: where b.business_group_id = p_business_group_id
125: and b.typ_cd = tl.typ_cd
126: and not exists
127: (select 'Y'