APPS.BEN_CWB_SUMMARY_PKG dependencies on BEN_PER_IN_LER

Line 190: from ben_per_in_ler pil

186: --
187: cursor c_pil is
188: select pil.person_id,
189: pil.lf_evt_ocrd_dt
190: from ben_per_in_ler pil
191: where pil.per_in_ler_id = p_sum_rec.group_per_in_ler_id;
192: --
193: l_dummy varchar2(1);
194: l_summary_id number;

Line 759: -- cursor to fetch the person_id from ben_per_in_ler for

755: -- Internal procedure to update the correct person_id in person_info record.
756: --
757: procedure update_person_info(p_group_pl_id in number
758: ,p_lf_evt_ocrd_dt in date) is
759: -- cursor to fetch the person_id from ben_per_in_ler for
760: -- group_per_in_ler_ids with -1 as person_id in ben_cwb_person_info
761: cursor csr_person_ids is
762: select pi.group_per_in_ler_id, pil.person_id
763: from ben_cwb_person_info pi

Line 764: ,ben_per_in_ler pil

760: -- group_per_in_ler_ids with -1 as person_id in ben_cwb_person_info
761: cursor csr_person_ids is
762: select pi.group_per_in_ler_id, pil.person_id
763: from ben_cwb_person_info pi
764: ,ben_per_in_ler pil
765: where pi.person_id = -1
766: and pi.group_pl_id = p_group_pl_id
767: and pi.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
768: and pi.group_per_in_ler_id = pil.per_in_ler_id

Line 774: ben_per_in_ler.person_id%type;

770: --
771: type group_per_in_ler_id_type is table of
772: ben_cwb_person_info.group_per_in_ler_id%type;
773: type person_id_type is table of
774: ben_per_in_ler.person_id%type;
775: -- declare pl/sql tables
776: l_group_per_in_ler_id_tab group_per_in_ler_id_type;
777: l_person_id_tab person_id_type;
778: --

Line 1424: ,ben_per_in_ler pil

1420: ,pil.person_id
1421: ,p_lf_evt_ocrd_dt
1422: from ben_cwb_group_hrchy hrchy
1423: ,ben_cwb_person_groups grp
1424: ,ben_per_in_ler pil
1425: where hrchy.lvl_num=0
1426: and hrchy.emp_per_in_ler_id = grp.group_per_in_ler_id
1427: and pil.group_pl_id = p_group_pl_id
1428: and pil.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt

Line 1850: ,ben_per_in_ler pil

1846: ,pil.person_id
1847: from ben_cwb_group_hrchy hrchy
1848: ,ben_cwb_person_info per
1849: ,ben_cwb_person_groups grp
1850: ,ben_per_in_ler pil
1851: where per.person_id = -1
1852: and per.group_per_in_ler_id = hrchy.emp_per_in_ler_id
1853: and hrchy.mgr_per_in_ler_id = grp.group_per_in_ler_id
1854: and grp.group_pl_id = p_group_pl_id

Line 3618: ,ben_per_in_ler pil

3614: ,grp.group_oipl_id
3615: ,pil.person_id
3616: ,pil.lf_evt_ocrd_dt
3617: from ben_cwb_person_groups grp
3618: ,ben_per_in_ler pil
3619: where grp.group_per_in_ler_id = p_new_mgr_per_in_ler_id
3620: and grp.group_per_in_ler_id = pil.per_in_ler_id
3621: and pil.per_in_ler_stat_cd in ('PROCD','STRTD')
3622: and not exists(select null