APPS.BEN_ENROLLMENT_ACTION_ITEMS dependencies on BEN_ACTN_TYP_TL

Line 1093: ben_actn_typ_tl tl

1089: --
1090: cursor c_act_name is
1091: select tl.name actn_typ_name
1092: from ben_actn_typ typ,
1093: ben_actn_typ_tl tl
1094: where p_actn_typ_id = typ.actn_typ_id
1095: and typ.actn_typ_id = tl.actn_typ_id
1096: and tl.language = userenv('lang')
1097: and typ.type_cd <> 'BNF'

Line 7675: ben_actn_typ_tl tl

7671:
7672: cursor c_act_name (v_actn_typ_id in number) is
7673: select tl.name actn_typ_name
7674: from ben_actn_typ typ,
7675: ben_actn_typ_tl tl
7676: where v_actn_typ_id = typ.actn_typ_id
7677: and typ.actn_typ_id = tl.actn_typ_id
7678: and tl.language = userenv('lang')
7679: and typ.type_cd <> 'BNF'

Line 7692: l_act_name ben_actn_typ_tl.name%TYPE;

7688: AND p_effective_date BETWEEN pl.effective_start_date
7689: AND pl.effective_end_date;
7690:
7691: plan_name_rec c_plan_name%ROWTYPE;
7692: l_act_name ben_actn_typ_tl.name%TYPE;
7693: l_message_name fnd_new_messages.message_name%TYPE := 'BEN_94108_BNF_ACT_ITEM';
7694: l_write_ctfn BOOLEAN;
7695: l_ff_ctfn_exits BOOLEAN;
7696: --