APPS.BEN_ENROLLMENT_ACTION_ITEMS dependencies on BEN_ACTN_TYP_TL

Line 1106: ben_actn_typ_tl tl

1102: --
1103: cursor c_act_name is
1104: select tl.name actn_typ_name
1105: from ben_actn_typ typ,
1106: ben_actn_typ_tl tl
1107: where p_actn_typ_id = typ.actn_typ_id
1108: and typ.actn_typ_id = tl.actn_typ_id
1109: and tl.language = userenv('lang')
1110: and typ.type_cd <> 'BNF'

Line 7760: ben_actn_typ_tl tl

7756:
7757: cursor c_act_name (v_actn_typ_id in number) is
7758: select tl.name actn_typ_name
7759: from ben_actn_typ typ,
7760: ben_actn_typ_tl tl
7761: where v_actn_typ_id = typ.actn_typ_id
7762: and typ.actn_typ_id = tl.actn_typ_id
7763: and tl.language = userenv('lang')
7764: and typ.type_cd <> 'BNF'

Line 7777: l_act_name ben_actn_typ_tl.name%TYPE;

7773: AND p_effective_date BETWEEN pl.effective_start_date
7774: AND pl.effective_end_date;
7775:
7776: plan_name_rec c_plan_name%ROWTYPE;
7777: l_act_name ben_actn_typ_tl.name%TYPE;
7778: l_message_name fnd_new_messages.message_name%TYPE := 'BEN_94108_BNF_ACT_ITEM';
7779: l_write_ctfn BOOLEAN;
7780: l_ff_ctfn_exits BOOLEAN;
7781: --