APPS.BEN_BACK_OUT_LIFE_EVENT dependencies on HR_LOOKUPS

Line 798: l_bckt_stat_cd hr_lookups.lookup_code%TYPE := p_bckt_stat_cd; --UTF8

794: -- and nvl(ppl.ntfn_dt, trunc(sysdate)) = nvl(cv_ntfn_dt, trunc(sysdate))
795: and ppl.PTNL_LER_FOR_PER_STAT_CD in ('DTCTD', 'UNPROCD', 'MNL', 'MNLO');
796: --
797: l_existing_ppl_rec c_ptnl_exist%rowtype;
798: l_bckt_stat_cd hr_lookups.lookup_code%TYPE := p_bckt_stat_cd; --UTF8
799: --
800: begin
801: --
802: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 3931: l_acty_ref_perd_cd hr_lookups.lookup_code%TYPE; -- UTF8

3927: l_pil_id number;
3928: l_rt_end_dt date;
3929: l_person_id number;
3930: l_acty_base_rt_id number;
3931: l_acty_ref_perd_cd hr_lookups.lookup_code%TYPE; -- UTF8
3932: l_business_group_id number;
3933: l_object_version_number number;
3934: l_effective_start_date date;
3935: l_effective_end_date date;