DBA Data[Home] [Help]

APPS.BEN_SEED_COMMUNICATION_TYPES dependencies on BEN_STARTUP_CM_TYP

Line 63: from ben_startup_cm_typ s_ct

59: nvl(to_be_sent_dt_cd, 'OED'),--4056466
60: 'N',
61: p_business_group_id,
62: 1
63: from ben_startup_cm_typ s_ct
64: where not exists (select 1
65: from ben_cm_typ_f ct
66: where s_ct.name = ct.name
67: and s_ct.shrt_name = ct.shrt_name

Line 99: ,ben_startup_cm_typ_tl tl

95: b.last_update_login,
96: b.created_by,
97: b.creation_date
98: from ben_cm_typ_f b
99: ,ben_startup_cm_typ_tl tl
100: where b.business_group_id = p_business_group_id
101: and b.shrt_name = tl.shrt_name
102: and not exists
103: (select 'Y'