APPS.BEN_ENROLLMENT_PROCESS dependencies on BEN_PL_BNF_F

Line 140: from ben_pl_bnf_f pbn

136: pbn.dsgn_strt_dt,
137: pbn.dsgn_thru_dt,
138: pbn.object_version_number,
139: pbn.effective_start_date
140: from ben_pl_bnf_f pbn
141: where pbn.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
142: and pbn.bnf_person_id = p_bnf_person_id
143: and p_effective_date between pbn.effective_start_date
144: and pbn.effective_end_date ;

Line 154: from ben_pl_bnf_f pbn

150: pbn.dsgn_strt_dt,
151: pbn.dsgn_thru_dt,
152: pbn.object_version_number,
153: pbn.effective_start_date
154: from ben_pl_bnf_f pbn
155: where pbn.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
156: and pbn.organization_id = p_organization_id
157: and p_effective_date between pbn.effective_start_date
158: and pbn.effective_end_date ;

Line 2539: l_amt_dsgd_val ben_pl_bnf_f.amt_dsgd_val%TYPE := p_amt_dsgd_val;

2535: l_life_event_date date := p_effective_date;
2536: l_prmry_cntngnt_cd varchar2(30) := p_prmry_cntngnt_cd;
2537: l_bnf_person_id number := p_bnf_person_id;
2538: l_pct_dsgd_num number := p_pct_dsgd_num;
2539: l_amt_dsgd_val ben_pl_bnf_f.amt_dsgd_val%TYPE := p_amt_dsgd_val;
2540: l_amt_dsgd_uom ben_pl_bnf_f.amt_dsgd_uom%TYPE := p_amt_dsgd_uom;
2541: l_addl_instrn_txt ben_pl_bnf_f.addl_instrn_txt%TYPE := p_addl_instrn_txt;
2542: l_organization_id number := p_organization_id;
2543: l_ttee_person_id number := p_ttee_person_id;

Line 2540: l_amt_dsgd_uom ben_pl_bnf_f.amt_dsgd_uom%TYPE := p_amt_dsgd_uom;

2536: l_prmry_cntngnt_cd varchar2(30) := p_prmry_cntngnt_cd;
2537: l_bnf_person_id number := p_bnf_person_id;
2538: l_pct_dsgd_num number := p_pct_dsgd_num;
2539: l_amt_dsgd_val ben_pl_bnf_f.amt_dsgd_val%TYPE := p_amt_dsgd_val;
2540: l_amt_dsgd_uom ben_pl_bnf_f.amt_dsgd_uom%TYPE := p_amt_dsgd_uom;
2541: l_addl_instrn_txt ben_pl_bnf_f.addl_instrn_txt%TYPE := p_addl_instrn_txt;
2542: l_organization_id number := p_organization_id;
2543: l_ttee_person_id number := p_ttee_person_id;
2544: l_bnf_actn_warning boolean;

Line 2541: l_addl_instrn_txt ben_pl_bnf_f.addl_instrn_txt%TYPE := p_addl_instrn_txt;

2537: l_bnf_person_id number := p_bnf_person_id;
2538: l_pct_dsgd_num number := p_pct_dsgd_num;
2539: l_amt_dsgd_val ben_pl_bnf_f.amt_dsgd_val%TYPE := p_amt_dsgd_val;
2540: l_amt_dsgd_uom ben_pl_bnf_f.amt_dsgd_uom%TYPE := p_amt_dsgd_uom;
2541: l_addl_instrn_txt ben_pl_bnf_f.addl_instrn_txt%TYPE := p_addl_instrn_txt;
2542: l_organization_id number := p_organization_id;
2543: l_ttee_person_id number := p_ttee_person_id;
2544: l_bnf_actn_warning boolean;
2545: l_suspend_flag varchar2(30);