APPS.BEN_BACK_OUT_LIFE_EVENT dependencies on HR_LOOKUPS

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

639: -- and nvl(ppl.ntfn_dt, trunc(sysdate)) = nvl(cv_ntfn_dt, trunc(sysdate))
640: and ppl.PTNL_LER_FOR_PER_STAT_CD in ('DTCTD', 'UNPROCD', 'MNL', 'MNLO');
641: --
642: l_existing_ppl_rec c_ptnl_exist%rowtype;
643: l_bckt_stat_cd hr_lookups.lookup_code%TYPE := p_bckt_stat_cd; --UTF8
644: --
645: begin
646: --
647: hr_utility.set_location('Entering:'|| l_proc, 10);

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

3451: l_pil_id number;
3452: l_rt_end_dt date;
3453: l_person_id number;
3454: l_acty_base_rt_id number;
3455: l_acty_ref_perd_cd hr_lookups.lookup_code%TYPE; -- UTF8
3456: l_business_group_id number;
3457: l_object_version_number number;
3458: l_effective_start_date date;
3459: l_effective_end_date date;