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_LF_EVT_CLPS_RESTORE dependencies on BEN_PL_BNF_F

Line 5203: from ben_pl_bnf_f pbn

5199: pbn.TTEE_PERSON_ID,
5200: pbn.BUSINESS_GROUP_ID,
5201: pbn.PER_IN_LER_ID,
5202: pbn.pbn_ATTRIBUTE_CATEGORY
5203: from ben_pl_bnf_f pbn
5204: where pbn.per_in_ler_id = p_bckdt_per_in_ler_id
5205: and pbn.prtt_enrt_rslt_id = p_bckdt_prtt_enrt_rslt_id
5206: and pbn.business_group_id = p_business_group_id
5207: union

Line 5272: and pbn.bkup_tbl_typ_cd = 'BEN_PL_BNF_F'

5268: and pbn.business_group_id = p_business_group_id
5269: and pbn.per_in_ler_id = p_bckdt_per_in_ler_id
5270: and p_effective_date between pbn.effective_start_date
5271: and pbn.effective_end_date
5272: and pbn.bkup_tbl_typ_cd = 'BEN_PL_BNF_F'
5273: order by 1;
5274: --
5275: l_old_pl_bnf_id number(15);
5276: l_pl_bnf_id number(15);

Line 5283: from ben_pl_bnf_f pbn

5279: l_bnf_object_version_number number(9);
5280: --
5281: cursor c_bnf(cp_bnf_person_id in number) is
5282: select pbn.*
5283: from ben_pl_bnf_f pbn
5284: where pbn.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5285: and pbn.bnf_person_id = cp_bnf_person_id
5286: and pbn.business_group_id = p_business_group_id
5287: -- and pbn.per_in_ler_id = p_per_in_ler_id --BUG Bug 4178570