APPS.BEN_PRTT_ENRT_RESULT_API dependencies on BEN_PL_BNF_F

Line 9168: from ben_pl_bnf_f pbf,

9164: ,pbf.object_version_number
9165: ,pbf.dsgn_strt_dt
9166: ,pbf.dsgn_thru_dt
9167: ,pbf.per_in_ler_id
9168: from ben_pl_bnf_f pbf,
9169: ben_per_in_ler pil
9170: where pbf.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
9171: and pbf.business_group_id = p_business_group_id
9172: and p_effective_date between pbf.effective_start_date

Line 9183: from ben_pl_bnf_f pbf,

9179: cursor c_zap_bnf
9180: is
9181: select pbf.pl_bnf_id
9182: ,pbf.object_version_number
9183: from ben_pl_bnf_f pbf,
9184: ben_per_in_ler pil
9185: where pbf.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
9186: and p_effective_date
9187: between pbf.effective_start_date

Line 9253: p_base_table_name => 'BEN_PL_BNF_F',

9249: --
9250:
9251: dt_api.find_dt_upd_modes
9252: (p_effective_date => p_effective_date,
9253: p_base_table_name => 'BEN_PL_BNF_F',
9254: p_base_key_column => 'PL_BNF_ID',
9255: p_base_key_value => orec.PL_BNF_ID,
9256: p_correction => l_correction,
9257: p_update => l_update,

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

10329: and p_effective_date between
10330: pdp.effective_start_date and pdp.effective_end_date))
10331: OR
10332: (pl.bnf_dsgn_cd is not null
10333: and not exists (select 'x' from ben_pl_bnf_f pbn
10334: where pbn.prtt_enrt_rslt_id = r.prtt_enrt_rslt_id
10335: and p_effective_date between
10336: pbn.effective_start_date and pbn.effective_end_date)));
10337: --