APPS.BEN_MNG_DPNT_BNF dependencies on BEN_PRTT_ENRT_ACTN_F

Line 719: from ben_prtt_enrt_actn_f pea,

715: pea.actn_typ_id,
716: pea.object_version_number,
717: pea.effective_start_date,
718: pea.effective_end_date
719: from ben_prtt_enrt_actn_f pea,
720: ben_actn_typ eat
721: where pea.elig_cvrd_dpnt_id = p_old_elig_cvrd_dpnt_id
722: and pea.prtt_enrt_rslt_id = p_old_prtt_enrt_rslt_id
723: and pea.cmpltd_dt is not null

Line 731: l_pea_object_version_number ben_prtt_enrt_actn_f.object_version_number%TYPE;

727: between pea.effective_start_date and pea.effective_end_date; -- bug 6793512
728: -- order by pea.prtt_enrt_actn_id,pea.effective_start_date,pea.effective_end_date;
729: --
730: l_dpnt_pea c_dpnt_pea%rowtype;
731: l_pea_object_version_number ben_prtt_enrt_actn_f.object_version_number%TYPE;
732: l_pea_effective_start_date ben_prtt_enrt_actn_f.effective_start_date%TYPE;
733: l_pea_effective_end_date ben_prtt_enrt_actn_f.effective_end_date%TYPE;
734: --
735: cursor c_ccp (ll_prtt_enrt_actn_id number) is

Line 732: l_pea_effective_start_date ben_prtt_enrt_actn_f.effective_start_date%TYPE;

728: -- order by pea.prtt_enrt_actn_id,pea.effective_start_date,pea.effective_end_date;
729: --
730: l_dpnt_pea c_dpnt_pea%rowtype;
731: l_pea_object_version_number ben_prtt_enrt_actn_f.object_version_number%TYPE;
732: l_pea_effective_start_date ben_prtt_enrt_actn_f.effective_start_date%TYPE;
733: l_pea_effective_end_date ben_prtt_enrt_actn_f.effective_end_date%TYPE;
734: --
735: cursor c_ccp (ll_prtt_enrt_actn_id number) is
736: select ccp.cvrd_dpnt_ctfn_prvdd_id

Line 733: l_pea_effective_end_date ben_prtt_enrt_actn_f.effective_end_date%TYPE;

729: --
730: l_dpnt_pea c_dpnt_pea%rowtype;
731: l_pea_object_version_number ben_prtt_enrt_actn_f.object_version_number%TYPE;
732: l_pea_effective_start_date ben_prtt_enrt_actn_f.effective_start_date%TYPE;
733: l_pea_effective_end_date ben_prtt_enrt_actn_f.effective_end_date%TYPE;
734: --
735: cursor c_ccp (ll_prtt_enrt_actn_id number) is
736: select ccp.cvrd_dpnt_ctfn_prvdd_id
737: ,ccp.effective_start_date

Line 863: p_base_table_name => 'ben_prtt_enrt_actn_f',

859: -- Bug 6793512
860: --
861: dt_api.find_dt_upd_modes
862: (p_effective_date => p_effective_date,
863: p_base_table_name => 'ben_prtt_enrt_actn_f',
864: p_base_key_column => 'prtt_enrt_actn_id',
865: p_base_key_value => l_dpnt_pea.prtt_enrt_actn_id,
866: p_correction => l_correction,
867: p_update => l_update,