DBA Data[Home] [Help]

APPS.BEN_UPDATE_LEDGERS dependencies on BEN_BNFT_PRVDD_LDGR_F

Line 22: from ben_bnft_prvdd_ldgr_f bpl,

18: select bpl.bnft_prvdd_ldgr_id, bpl.acty_base_rt_id, bpl.prtt_enrt_rslt_id,
19: bpl.business_group_id, bpl.effective_start_date, bpl.effective_end_date,
20: bpl.object_version_number, bpl.per_in_ler_id,
21: bpl.frftd_val, bpl.used_val, bpl.prvdd_val, bpl.cash_recd_val, bpl.rld_up_val
22: from ben_bnft_prvdd_ldgr_f bpl,
23: ben_per_in_ler pil,
24: ben_prtt_enrt_rslt_f pen
25: where (bpl.acty_ref_perd_cd is null or
26: (bpl.used_val is not null and bpl.cmcd_used_val is null))

Line 189: from ben_bnft_prvdd_ldgr_f bpl

185: cursor c_ldgr(c_bnft_prvdd_ldgr_id in number,
186: c_effective_date in date) is
187: select bpl.acty_base_rt_id, bpl.prtt_enrt_rslt_id,
188: bpl.business_group_id, bpl.per_in_ler_id
189: from ben_bnft_prvdd_ldgr_f bpl
190: where bpl.bnft_prvdd_ldgr_id = c_bnft_prvdd_ldgr_id
191: and c_effective_date between
192: bpl.effective_start_date and bpl.effective_end_date;
193: l_ldgr c_ldgr%rowtype;

Line 890: p_base_table_name => 'BEN_BNFT_PRVDD_LDGR_F',

886: --
887: -- Get the appropriate update mode.
888: --
889: DT_Api.Find_DT_Upd_Modes(p_effective_date => p_effective_date,
890: p_base_table_name => 'BEN_BNFT_PRVDD_LDGR_F',
891: p_base_key_column => 'BNFT_PRVDD_LDGR_ID',
892: p_base_key_value => p_base_key_value,
893: p_correction => l_correction,
894: p_update => l_update,