APPS.BEN_MNG_DPNT_BNF dependencies on BEN_PRTT_ENRT_ACTN_F

Line 867: from ben_prtt_enrt_actn_f pea,

863: pea.actn_typ_id,
864: pea.object_version_number,
865: pea.effective_start_date,
866: pea.effective_end_date
867: from ben_prtt_enrt_actn_f pea,
868: ben_actn_typ eat
869: where pea.elig_cvrd_dpnt_id = p_old_elig_cvrd_dpnt_id
870: and pea.prtt_enrt_rslt_id = p_old_prtt_enrt_rslt_id
871: and pea.cmpltd_dt is not null

Line 879: l_pea_object_version_number ben_prtt_enrt_actn_f.object_version_number%TYPE;

875: between pea.effective_start_date and pea.effective_end_date; -- bug 6793512
876: -- order by pea.prtt_enrt_actn_id,pea.effective_start_date,pea.effective_end_date;
877: --
878: l_dpnt_pea c_dpnt_pea%rowtype;
879: l_pea_object_version_number ben_prtt_enrt_actn_f.object_version_number%TYPE;
880: l_pea_effective_start_date ben_prtt_enrt_actn_f.effective_start_date%TYPE;
881: l_pea_effective_end_date ben_prtt_enrt_actn_f.effective_end_date%TYPE;
882: --
883: cursor c_ccp (ll_prtt_enrt_actn_id number) is

Line 880: l_pea_effective_start_date ben_prtt_enrt_actn_f.effective_start_date%TYPE;

876: -- order by pea.prtt_enrt_actn_id,pea.effective_start_date,pea.effective_end_date;
877: --
878: l_dpnt_pea c_dpnt_pea%rowtype;
879: l_pea_object_version_number ben_prtt_enrt_actn_f.object_version_number%TYPE;
880: l_pea_effective_start_date ben_prtt_enrt_actn_f.effective_start_date%TYPE;
881: l_pea_effective_end_date ben_prtt_enrt_actn_f.effective_end_date%TYPE;
882: --
883: cursor c_ccp (ll_prtt_enrt_actn_id number) is
884: select ccp.cvrd_dpnt_ctfn_prvdd_id

Line 881: l_pea_effective_end_date ben_prtt_enrt_actn_f.effective_end_date%TYPE;

877: --
878: l_dpnt_pea c_dpnt_pea%rowtype;
879: l_pea_object_version_number ben_prtt_enrt_actn_f.object_version_number%TYPE;
880: l_pea_effective_start_date ben_prtt_enrt_actn_f.effective_start_date%TYPE;
881: l_pea_effective_end_date ben_prtt_enrt_actn_f.effective_end_date%TYPE;
882: --
883: cursor c_ccp (ll_prtt_enrt_actn_id number) is
884: select ccp.cvrd_dpnt_ctfn_prvdd_id
885: ,ccp.effective_start_date

Line 1016: p_base_table_name => 'ben_prtt_enrt_actn_f',

1012: -- Bug 6793512
1013: --
1014: dt_api.find_dt_upd_modes
1015: (p_effective_date => p_effective_date,
1016: p_base_table_name => 'ben_prtt_enrt_actn_f',
1017: p_base_key_column => 'prtt_enrt_actn_id',
1018: p_base_key_value => l_dpnt_pea.prtt_enrt_actn_id,
1019: p_correction => l_correction,
1020: p_update => l_update,