APPS.BEN_LER_SHD dependencies on BEN_LER_F_TL

Line 308: update ben_ler_f_tl t

304: where t.ler_id = p_base_key_value
305: and p_effective_date
306: between t.effective_start_date and t.effective_end_date;
307: --
308: update ben_ler_f_tl t
309: set t.effective_end_date = p_new_effective_end_date,
310: t.last_update_date = sysdate,
311: t.last_updated_by = fnd_global.user_id,
312: t.last_update_login = fnd_global.login_id

Line 774: delete from ben_ler_f_tl t

770: -- ----------------------------------------------------------------------------
771: Procedure add_language
772: is
773: begin
774: delete from ben_ler_f_tl t
775: where not exists
776: (select null
777: from ben_ler_f_tl b
778: where b.ler_id = t.ler_id

Line 777: from ben_ler_f_tl b

773: begin
774: delete from ben_ler_f_tl t
775: where not exists
776: (select null
777: from ben_ler_f_tl b
778: where b.ler_id = t.ler_id
779: and b.effective_start_date = t.effective_start_date
780: );
781:

Line 782: update ben_ler_f_tl t set (

778: where b.ler_id = t.ler_id
779: and b.effective_start_date = t.effective_start_date
780: );
781:
782: update ben_ler_f_tl t set (
783: typ_cd,
784: name
785: ) = (select
786: b.typ_cd,

Line 788: from ben_ler_f_tl b

784: name
785: ) = (select
786: b.typ_cd,
787: b.name
788: from ben_ler_f_tl b
789: where b.ler_id = t.ler_id
790: and b.effective_start_date = t.effective_start_date
791: and b.language = t.source_lang)
792: where (

Line 800: from ben_ler_f_tl subb, ben_ler_f_tl subt

796: ) in (select
797: subt.ler_id,
798: subt.effective_start_date,
799: subt.language
800: from ben_ler_f_tl subb, ben_ler_f_tl subt
801: where subb.ler_id = subt.ler_id
802: and subb.effective_start_date = subt.effective_start_date
803: and subb.language = subt.source_lang
804: and (subb.name <> subt.name

Line 808: insert into ben_ler_f_tl (

804: and (subb.name <> subt.name
805: or subb.typ_cd <> subt.typ_cd
806: ));
807:
808: insert into ben_ler_f_tl (
809: ler_id,
810: effective_start_date,
811: effective_end_date,
812: typ_cd,

Line 836: from ben_ler_f_tl b, fnd_languages l

832: b.last_updated_by,
833: b.last_update_login,
834: b.created_by,
835: b.creation_date
836: from ben_ler_f_tl b, fnd_languages l
837: where l.installed_flag in ('I', 'B')
838: and b.language = userenv('LANG')
839: and not exists
840: (select null

Line 841: from ben_ler_f_tl t

837: where l.installed_flag in ('I', 'B')
838: and b.language = userenv('LANG')
839: and not exists
840: (select null
841: from ben_ler_f_tl t
842: where t.ler_id = b.ler_id
843: and t.effective_start_date = b.effective_start_date
844: and t.language = l.language_code);
845: end add_language;