DBA Data[Home] [Help]

APPS.BEN_CWB_PERSON_INFO_PKG dependencies on BEN_CWB_PL_DSGN

Line 763: from ben_cwb_pl_dsgn pldsgn

759: select pldsgn.emp_interview_typ_cd, pldsgn.data_freeze_date,
760: pil.lf_evt_ocrd_dt, pil.group_pl_id, pil.assignment_id
761: into l_performance_rating_type, l_data_freeze_date,
762: l_lf_evt_ocrd_dt, l_group_pl_id, l_assignment_id
763: from ben_cwb_pl_dsgn pldsgn
764: ,ben_per_in_ler pil
765: where pil.per_in_ler_id = p_group_per_in_ler_id
766: and pil.group_pl_id = pldsgn.pl_id
767: and pil.lf_evt_ocrd_dt = pldsgn.lf_evt_ocrd_dt

Line 1740: -- info. This procedure checks if th effective_date column in ben_cwb_pl_dsgn

1736: -- |--------------------------< refresh_from_master >-----------------------|
1737: -- --------------------------------------------------------------------------
1738: -- Description
1739: -- This procedure is used only by the admin page to refresh the person
1740: -- info. This procedure checks if th effective_date column in ben_cwb_pl_dsgn
1741: -- is null. If it is, the p_effective_date will be passed to
1742: -- refresh_person_info. Otherwise null will be passed to refresh_person_info
1743: -- so that it will use effective_date column in pl_dsgn.
1744: procedure refresh_from_master(p_group_per_in_ler_id in number

Line 1758: from ben_cwb_pl_dsgn pl

1754: hr_utility.set_location('Entering:'|| l_proc, 10);
1755: end if;
1756: --
1757: select pl.effective_date into l_effective_date
1758: from ben_cwb_pl_dsgn pl
1759: ,ben_per_in_ler pil
1760: where pil.per_in_ler_id = p_group_per_in_ler_id
1761: and pl.pl_id = pil.group_pl_id
1762: and pl.lf_evt_ocrd_dt = pil.lf_evt_ocrd_dt