APPS.BEN_REG_SHD dependencies on BEN_REGN_F_TL

Line 277: update ben_regn_f_tl t

273: between t.effective_start_date and t.effective_end_date;
274: --
275: -- Update MLS table.
276: --
277: update ben_regn_f_tl t
278: set t.effective_end_date = p_new_effective_end_date,
279: t.last_update_date = sysdate,
280: t.last_updated_by = fnd_global.user_id,
281: t.last_update_login = fnd_global.login_id

Line 574: delete from ben_regn_f_tl t

570: -- ----------------------------------------------------------------------------
571: Procedure add_language
572: is
573: begin
574: delete from ben_regn_f_tl t
575: where not exists
576: (select null
577: from ben_regn_f_tl b
578: where b.regn_id = t.regn_id

Line 577: from ben_regn_f_tl b

573: begin
574: delete from ben_regn_f_tl t
575: where not exists
576: (select null
577: from ben_regn_f_tl b
578: where b.regn_id = t.regn_id
579: and b.effective_start_date = t.effective_start_date
580: );
581:

Line 582: update ben_regn_f_tl t set (

578: where b.regn_id = t.regn_id
579: and b.effective_start_date = t.effective_start_date
580: );
581:
582: update ben_regn_f_tl t set (
583: name,
584: sttry_citn_name
585: ) = (select
586: b.name,

Line 588: from ben_regn_f_tl b

584: sttry_citn_name
585: ) = (select
586: b.name,
587: b.sttry_citn_name
588: from ben_regn_f_tl b
589: where b.regn_id = t.regn_id
590: and b.effective_start_date = t.effective_start_date
591: and b.language = t.source_lang)
592: where (

Line 600: from ben_regn_f_tl subb, ben_regn_f_tl subt

596: ) in (select
597: subt.regn_id,
598: subt.effective_start_date,
599: subt.language
600: from ben_regn_f_tl subb, ben_regn_f_tl subt
601: where subb.regn_id = subt.regn_id
602: and subb.effective_start_date = subt.effective_start_date
603: and subb.language = subt.source_lang
604: and (subb.name <> subt.name

Line 608: insert into ben_regn_f_tl (

604: and (subb.name <> subt.name
605: or subb.sttry_citn_name <> subt.sttry_citn_name
606: ));
607:
608: insert into ben_regn_f_tl (
609: regn_id,
610: effective_start_date,
611: effective_end_date,
612: name,

Line 634: from ben_regn_f_tl b, fnd_languages l

630: b.last_updated_by,
631: b.last_update_login,
632: b.created_by,
633: b.creation_date
634: from ben_regn_f_tl b, fnd_languages l
635: where l.installed_flag in ('I', 'B')
636: and b.language = userenv('LANG')
637: and not exists
638: (select null

Line 639: from ben_regn_f_tl t

635: where l.installed_flag in ('I', 'B')
636: and b.language = userenv('LANG')
637: and not exists
638: (select null
639: from ben_regn_f_tl t
640: where t.regn_id = b.regn_id
641: and t.effective_start_date = b.effective_start_date
642: and t.language = l.language_code);
643: end add_language;