APPS.BEN_ENROLLMENT_ACTION_ITEMS dependencies on BEN_ACTN_TYP

Line 764: -- Return the actn_typ_id or NULL when given the ben_actn_typ.type_cd

760: (p_type_cd in varchar2
761: ,p_business_group_id in number)
762: return number is
763: --
764: -- Return the actn_typ_id or NULL when given the ben_actn_typ.type_cd
765: -- type_cd examples DDDOB, DDSSN, BNFADDR, etc.
766: -- note: future improvement could be to get this list once and then find
767: -- the values from the pl/sql record
768: --

Line 770: l_actn_typ_id ben_actn_typ.actn_typ_id%type := NULL;

766: -- note: future improvement could be to get this list once and then find
767: -- the values from the pl/sql record
768: --
769: l_proc varchar2(80);
770: l_actn_typ_id ben_actn_typ.actn_typ_id%type := NULL;
771: --
772: cursor c_actn_typ_id is
773: select bat.actn_typ_id
774: from ben_actn_typ bat

Line 774: from ben_actn_typ bat

770: l_actn_typ_id ben_actn_typ.actn_typ_id%type := NULL;
771: --
772: cursor c_actn_typ_id is
773: select bat.actn_typ_id
774: from ben_actn_typ bat
775: where bat.type_cd = p_type_cd
776: and bat.business_group_id = p_business_group_id;
777: --
778: begin

Line 1105: from ben_actn_typ typ,

1101: ,p_prtt_enrt_actn_id out nocopy number) is
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')

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 4672: ben_actn_typ typ,

4668: cursor c_other_dpnt_actn_items is
4669: select pea.prtt_enrt_actn_id,
4670: pea.object_version_number
4671: from ben_prtt_enrt_actn_f pea,
4672: ben_actn_typ typ,
4673: ben_per_in_ler pil
4674: where pea.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
4675: and pea.business_group_id = p_business_group_id
4676: and typ.type_cd <> 'DD'

Line 7495: ben_actn_typ eat

7491: --
7492: cursor c_bnf_actn_item is
7493: select null
7494: from ben_popl_actn_typ_f pat,
7495: ben_actn_typ eat
7496: where pat.pl_id = p_pl_id
7497: and pat.actn_typ_id = eat.actn_typ_id
7498: and eat.type_cd = p_actn_type_cd
7499: and pat.business_group_id = p_business_group_id

Line 7759: from ben_actn_typ typ,

7755: AND effective_end_date;
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')

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: --

Line 8510: ben_actn_typ typ,

8506: cursor c_other_bnf_actn_items is
8507: select pea.prtt_enrt_actn_id,
8508: pea.object_version_number
8509: from ben_prtt_enrt_actn_f pea,
8510: ben_actn_typ typ,
8511: ben_per_in_ler pil
8512: where pea.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
8513: and pea.business_group_id = p_business_group_id
8514: and typ.type_cd <> 'BNF'