APPS.BEN_CCT_SHD dependencies on BEN_CM_TYP_F_TL

Line 300: update ben_cm_typ_f_tl t

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

Line 641: delete from ben_cm_typ_f_tl t

637: -- ----------------------------------------------------------------------------
638: Procedure add_language
639: is
640: begin
641: delete from ben_cm_typ_f_tl t
642: where not exists
643: (select null
644: from ben_cm_typ_f_tl b
645: where b.cm_typ_id = t.cm_typ_id

Line 644: from ben_cm_typ_f_tl b

640: begin
641: delete from ben_cm_typ_f_tl t
642: where not exists
643: (select null
644: from ben_cm_typ_f_tl b
645: where b.cm_typ_id = t.cm_typ_id
646: and b.effective_start_date = t.effective_start_date
647: );
648:

Line 649: update ben_cm_typ_f_tl t set (

645: where b.cm_typ_id = t.cm_typ_id
646: and b.effective_start_date = t.effective_start_date
647: );
648:
649: update ben_cm_typ_f_tl t set (
650: shrt_name,
651: name
652: ) = (select
653: b.shrt_name,

Line 655: from ben_cm_typ_f_tl b

651: name
652: ) = (select
653: b.shrt_name,
654: b.name
655: from ben_cm_typ_f_tl b
656: where b.cm_typ_id = t.cm_typ_id
657: and b.effective_start_date = t.effective_start_date
658: and b.language = t.source_lang)
659: where (

Line 667: from ben_cm_typ_f_tl subb, ben_cm_typ_f_tl subt

663: ) in (select
664: subt.cm_typ_id,
665: subt.effective_start_date,
666: subt.language
667: from ben_cm_typ_f_tl subb, ben_cm_typ_f_tl subt
668: where subb.cm_typ_id = subt.cm_typ_id
669: and subb.effective_start_date = subt.effective_start_date
670: and subb.language = subt.source_lang
671: and (subb.name <> subt.name

Line 675: insert into ben_cm_typ_f_tl (

671: and (subb.name <> subt.name
672: or subb.shrt_name <> subt.shrt_name
673: ));
674: --
675: insert into ben_cm_typ_f_tl (
676: cm_typ_id,
677: effective_start_date,
678: effective_end_date,
679: shrt_name,

Line 701: from ben_cm_typ_f_tl b, fnd_languages l

697: b.last_updated_by,
698: b.last_update_login,
699: b.created_by,
700: b.creation_date
701: from ben_cm_typ_f_tl b, fnd_languages l
702: where l.installed_flag in ('I', 'B')
703: and b.language = userenv('LANG')
704: and not exists
705: (select null

Line 706: from ben_cm_typ_f_tl t

702: where l.installed_flag in ('I', 'B')
703: and b.language = userenv('LANG')
704: and not exists
705: (select null
706: from ben_cm_typ_f_tl t
707: where t.cm_typ_id = b.cm_typ_id
708: and t.effective_start_date = b.effective_start_date
709: and t.language = l.language_code);
710: end add_language;