APPS.BEN_PRTT_ENRT_RESULT_API dependencies on BEN_PL_BNF_F

Line 10762: from ben_pl_bnf_f pbf,

10758: ,pbf.object_version_number
10759: ,pbf.dsgn_strt_dt
10760: ,pbf.dsgn_thru_dt
10761: ,pbf.per_in_ler_id
10762: from ben_pl_bnf_f pbf,
10763: ben_per_in_ler pil
10764: where pbf.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
10765: and pbf.business_group_id = p_business_group_id
10766: and p_effective_date between pbf.effective_start_date

Line 10777: from ben_pl_bnf_f pbf,

10773: cursor c_zap_bnf
10774: is
10775: select pbf.pl_bnf_id
10776: ,pbf.object_version_number
10777: from ben_pl_bnf_f pbf,
10778: ben_per_in_ler pil
10779: where pbf.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
10780: and p_effective_date
10781: between pbf.effective_start_date

Line 10847: p_base_table_name => 'BEN_PL_BNF_F',

10843: --
10844:
10845: dt_api.find_dt_upd_modes
10846: (p_effective_date => p_effective_date,
10847: p_base_table_name => 'BEN_PL_BNF_F',
10848: p_base_key_column => 'PL_BNF_ID',
10849: p_base_key_value => orec.PL_BNF_ID,
10850: p_correction => l_correction,
10851: p_update => l_update,

Line 11931: and not exists (select 'x' from ben_pl_bnf_f pbn

11927: and p_effective_date between
11928: pdp.effective_start_date and pdp.effective_end_date))
11929: OR
11930: (pl.bnf_dsgn_cd is not null
11931: and not exists (select 'x' from ben_pl_bnf_f pbn
11932: where pbn.prtt_enrt_rslt_id = r.prtt_enrt_rslt_id
11933: and p_effective_date between
11934: pbn.effective_start_date and pbn.effective_end_date)));
11935: --