[Home] [Help]
752: cursor csr_grp_plan_extra_info(p_group_pl_id number, p_lf_evt_ocrd_dt date)
753: is
754: select nvl(pl_dsgn.show_appraisals_n_days,pl_info.pli_information4) show_appraisals_n_days
755: from ben_pl_extra_info pl_info,
756: ben_cwb_pl_dsgn pl_dsgn
757: where pl_dsgn.pl_id = p_group_pl_id
758: and pl_dsgn.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
759: and pl_info.information_type(+) = 'CWB_CUSTOM_DOWNLOAD'
760: and pl_info.pl_id(+) = pl_dsgn.pl_id;
800: select pldsgn.emp_interview_typ_cd, pldsgn.data_freeze_date,
801: pil.lf_evt_ocrd_dt, pil.group_pl_id, pil.assignment_id
802: into l_performance_rating_type, l_data_freeze_date,
803: l_lf_evt_ocrd_dt, l_group_pl_id, l_assignment_id
804: from ben_cwb_pl_dsgn pldsgn
805: ,ben_per_in_ler pil
806: where pil.per_in_ler_id = p_group_per_in_ler_id
807: and pil.group_pl_id = pldsgn.pl_id
808: and pil.lf_evt_ocrd_dt = pldsgn.lf_evt_ocrd_dt
1797: -- |--------------------------< refresh_from_master >-----------------------|
1798: -- --------------------------------------------------------------------------
1799: -- Description
1800: -- This procedure is used only by the admin page to refresh the person
1801: -- info. This procedure checks if th effective_date column in ben_cwb_pl_dsgn
1802: -- is null. If it is, the p_effective_date will be passed to
1803: -- refresh_person_info. Otherwise null will be passed to refresh_person_info
1804: -- so that it will use effective_date column in pl_dsgn.
1805: procedure refresh_from_master(p_group_per_in_ler_id in number
1815: hr_utility.set_location('Entering:'|| l_proc, 10);
1816: end if;
1817: --
1818: select pl.effective_date into l_effective_date
1819: from ben_cwb_pl_dsgn pl
1820: ,ben_per_in_ler pil
1821: where pil.per_in_ler_id = p_group_per_in_ler_id
1822: and pl.pl_id = pil.group_pl_id
1823: and pl.lf_evt_ocrd_dt = pil.lf_evt_ocrd_dt