APPS.BEN_CWB_PERSON_INFO_PKG dependencies on BEN_PER_IN_LER

Line 635: ,ben_per_in_ler pil

631: ,ppp.pay_proposal_id current_pay_proposal_id
632: ,perf.appraisal_id appraisal_id
633: from per_all_people_f ppf
634: ,per_all_assignments_f paf
635: ,ben_per_in_ler pil
636: ,per_all_people_f supv
637: ,per_all_assignments_f supv_asg
638: ,hr_organization_information bg
639: ,hr_organization_information supv_bg

Line 764: ,ben_per_in_ler pil

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

Line 1482: from ben_per_in_ler pil

1478: ,p_effective_date in date) is
1479:
1480: cursor csr_pil is
1481: select pil.per_in_ler_id
1482: from ben_per_in_ler pil
1483: where pil.group_pl_id = p_group_pl_id
1484: and pil.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
1485: and pil.assignment_id is not null
1486: and pil.per_in_ler_stat_cd in ('STRTD','PROCD');

Line 1759: ,ben_per_in_ler pil

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