APPS.BEN_EAT_SHD dependencies on BEN_ACTN_TYP_TL

Line 366: delete from ben_actn_typ_tl t

362: -- ----------------------------------------------------------------------------
363: Procedure add_language
364: is
365: begin
366: delete from ben_actn_typ_tl t
367: where not exists
368: (select null
369: from ben_actn_typ_tl b
370: where b.actn_typ_id = t.actn_typ_id

Line 369: from ben_actn_typ_tl b

365: begin
366: delete from ben_actn_typ_tl t
367: where not exists
368: (select null
369: from ben_actn_typ_tl b
370: where b.actn_typ_id = t.actn_typ_id
371: );
372:
373: update ben_actn_typ_tl t set (

Line 373: update ben_actn_typ_tl t set (

369: from ben_actn_typ_tl b
370: where b.actn_typ_id = t.actn_typ_id
371: );
372:
373: update ben_actn_typ_tl t set (
374: name,
375: description,
376: type_cd
377: ) = (select

Line 381: from ben_actn_typ_tl b

377: ) = (select
378: b.name,
379: b.description,
380: b.type_cd
381: from ben_actn_typ_tl b
382: where b.actn_typ_id = t.actn_typ_id
383: and b.language = t.source_lang)
384: where (
385: t.actn_typ_id,

Line 390: from ben_actn_typ_tl subb, ben_actn_typ_tl subt

386: t.language
387: ) in (select
388: subt.actn_typ_id,
389: subt.language
390: from ben_actn_typ_tl subb, ben_actn_typ_tl subt
391: where subb.actn_typ_id = subt.actn_typ_id
392: and subb.language = subt.source_lang
393: and (subb.name <> subt.name
394: or subb.description <> subt.description

Line 397: insert into ben_actn_typ_tl (

393: and (subb.name <> subt.name
394: or subb.description <> subt.description
395: or subb.type_cd <> subt.type_cd
396: ));
397: insert into ben_actn_typ_tl (
398: actn_typ_id,
399: name,
400: description,
401: language,

Line 421: from ben_actn_typ_tl b, fnd_languages l

417: b.last_updated_by,
418: b.last_update_login,
419: b.created_by,
420: b.creation_date
421: from ben_actn_typ_tl b, fnd_languages l
422: where l.installed_flag in ('I', 'B')
423: and b.language = userenv('LANG')
424: and not exists
425: (select null

Line 426: from ben_actn_typ_tl t

422: where l.installed_flag in ('I', 'B')
423: and b.language = userenv('LANG')
424: and not exists
425: (select null
426: from ben_actn_typ_tl t
427: where t.actn_typ_id = b.actn_typ_id
428: and t.language = l.language_code);
429: end add_language;
430: --