eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_ENROLLMENT_PROCESS dependencies on BEN_PL_BNF_F

Line 137: from ben_pl_bnf_f pbn

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

Line 151: from ben_pl_bnf_f pbn

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

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

2502: l_life_event_date date := p_effective_date;
2503: l_prmry_cntngnt_cd varchar2(30) := p_prmry_cntngnt_cd;
2504: l_bnf_person_id number := p_bnf_person_id;
2505: l_pct_dsgd_num number := p_pct_dsgd_num;
2506: l_amt_dsgd_val ben_pl_bnf_f.amt_dsgd_val%TYPE := p_amt_dsgd_val;
2507: l_amt_dsgd_uom ben_pl_bnf_f.amt_dsgd_uom%TYPE := p_amt_dsgd_uom;
2508: l_addl_instrn_txt ben_pl_bnf_f.addl_instrn_txt%TYPE := p_addl_instrn_txt;
2509: l_organization_id number := p_organization_id;
2510: l_ttee_person_id number := p_ttee_person_id;

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

2503: l_prmry_cntngnt_cd varchar2(30) := p_prmry_cntngnt_cd;
2504: l_bnf_person_id number := p_bnf_person_id;
2505: l_pct_dsgd_num number := p_pct_dsgd_num;
2506: l_amt_dsgd_val ben_pl_bnf_f.amt_dsgd_val%TYPE := p_amt_dsgd_val;
2507: l_amt_dsgd_uom ben_pl_bnf_f.amt_dsgd_uom%TYPE := p_amt_dsgd_uom;
2508: l_addl_instrn_txt ben_pl_bnf_f.addl_instrn_txt%TYPE := p_addl_instrn_txt;
2509: l_organization_id number := p_organization_id;
2510: l_ttee_person_id number := p_ttee_person_id;
2511: l_bnf_actn_warning boolean;

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

2504: l_bnf_person_id number := p_bnf_person_id;
2505: l_pct_dsgd_num number := p_pct_dsgd_num;
2506: l_amt_dsgd_val ben_pl_bnf_f.amt_dsgd_val%TYPE := p_amt_dsgd_val;
2507: l_amt_dsgd_uom ben_pl_bnf_f.amt_dsgd_uom%TYPE := p_amt_dsgd_uom;
2508: l_addl_instrn_txt ben_pl_bnf_f.addl_instrn_txt%TYPE := p_addl_instrn_txt;
2509: l_organization_id number := p_organization_id;
2510: l_ttee_person_id number := p_ttee_person_id;
2511: l_bnf_actn_warning boolean;
2512: l_suspend_flag varchar2(30);