APPS.BEN_CWB_PERSON_INFO_PKG dependencies on BEN_PL_EXTRA_INFO

Line 359: select PLI_INFORMATION2 from ben_pl_extra_info

355: l_performance_rating_type ben_cwb_person_info.performance_rating_type%type;
356:
357: --vkodedal cursor to fetch survey_id from eit setup.
358: cursor c_survey_id(l_group_pl_id in number) is
359: select PLI_INFORMATION2 from ben_pl_extra_info
360: where INFORMATION_TYPE='CWB_CUSTOM_DOWNLOAD'
361: and pl_id=l_group_pl_id;
362: --
363: -- cursor to fetch the person information

Line 755: from ben_pl_extra_info pl_info,

751: --Bug fix 9760967
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'