APPS.BEN_CCT_SHD dependencies on BEN_CM_TYP_F_TL

Line 302: update ben_cm_typ_f_tl t

298: where t.cm_typ_id = p_base_key_value
299: and p_effective_date
300: between t.effective_start_date and t.effective_end_date;
301: --
302: update ben_cm_typ_f_tl t
303: set t.effective_end_date = p_new_effective_end_date,
304: t.last_update_date = sysdate,
305: t.last_updated_by = fnd_global.user_id,
306: t.last_update_login = fnd_global.login_id

Line 646: delete from ben_cm_typ_f_tl t

642: -- ----------------------------------------------------------------------------
643: Procedure add_language
644: is
645: begin
646: delete from ben_cm_typ_f_tl t
647: where not exists
648: (select null
649: from ben_cm_typ_f_tl b
650: where b.cm_typ_id = t.cm_typ_id

Line 649: from ben_cm_typ_f_tl b

645: begin
646: delete from ben_cm_typ_f_tl t
647: where not exists
648: (select null
649: from ben_cm_typ_f_tl b
650: where b.cm_typ_id = t.cm_typ_id
651: and b.effective_start_date = t.effective_start_date
652: );
653:

Line 654: update ben_cm_typ_f_tl t set (

650: where b.cm_typ_id = t.cm_typ_id
651: and b.effective_start_date = t.effective_start_date
652: );
653:
654: update ben_cm_typ_f_tl t set (
655: shrt_name,
656: name
657: ) = (select
658: b.shrt_name,

Line 660: from ben_cm_typ_f_tl b

656: name
657: ) = (select
658: b.shrt_name,
659: b.name
660: from ben_cm_typ_f_tl b
661: where b.cm_typ_id = t.cm_typ_id
662: and b.effective_start_date = t.effective_start_date
663: and b.language = t.source_lang)
664: where (

Line 672: from ben_cm_typ_f_tl subb, ben_cm_typ_f_tl subt

668: ) in (select
669: subt.cm_typ_id,
670: subt.effective_start_date,
671: subt.language
672: from ben_cm_typ_f_tl subb, ben_cm_typ_f_tl subt
673: where subb.cm_typ_id = subt.cm_typ_id
674: and subb.effective_start_date = subt.effective_start_date
675: and subb.language = subt.source_lang
676: and (subb.name <> subt.name

Line 680: insert into ben_cm_typ_f_tl (

676: and (subb.name <> subt.name
677: or subb.shrt_name <> subt.shrt_name
678: ));
679: --
680: insert into ben_cm_typ_f_tl (
681: cm_typ_id,
682: effective_start_date,
683: effective_end_date,
684: shrt_name,

Line 706: from ben_cm_typ_f_tl b, fnd_languages l

702: b.last_updated_by,
703: b.last_update_login,
704: b.created_by,
705: b.creation_date
706: from ben_cm_typ_f_tl b, fnd_languages l
707: where l.installed_flag in ('I', 'B')
708: and b.language = userenv('LANG')
709: and not exists
710: (select null

Line 711: from ben_cm_typ_f_tl t

707: where l.installed_flag in ('I', 'B')
708: and b.language = userenv('LANG')
709: and not exists
710: (select null
711: from ben_cm_typ_f_tl t
712: where t.cm_typ_id = b.cm_typ_id
713: and t.effective_start_date = b.effective_start_date
714: and t.language = l.language_code);
715: end add_language;