APPS.BEN_CWB_PERSON_INFO_PKG dependencies on BEN_PER_IN_LER

Line 658: ,ben_per_in_ler pil

654: AND event_id = perf.event_id)
655: END ) appraisal_id
656: from per_all_people_f ppf
657: ,per_all_assignments_f paf
658: ,ben_per_in_ler pil
659: ,per_all_people_f supv
660: ,per_all_assignments_f supv_asg
661: ,hr_organization_information bg
662: ,hr_organization_information supv_bg

Line 805: ,ben_per_in_ler pil

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
809: and pldsgn.oipl_id = -1 ;

Line 1543: from ben_per_in_ler pil

1539: ,p_effective_date in date) is
1540:
1541: cursor csr_pil is
1542: select pil.per_in_ler_id
1543: from ben_per_in_ler pil
1544: where pil.group_pl_id = p_group_pl_id
1545: and pil.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
1546: and pil.assignment_id is not null
1547: and pil.per_in_ler_stat_cd in ('STRTD','PROCD');

Line 1820: ,ben_per_in_ler pil

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
1824: and pl.group_oipl_id = -1;