APPS.BEN_PERSON_LIFE_EVENT_API dependencies on BEN_PER_IN_LER

Line 126: from ben_prtt_enrt_rslt_f pen, ben_per_in_ler pil

122: cursor c_sspndd_rslt is
123: select pen.prtt_enrt_rslt_id,
124: pen.object_version_number,
125: pil.per_in_ler_id
126: from ben_prtt_enrt_rslt_f pen, ben_per_in_ler pil
127: where pil.person_id = p_person_id
128: and pil.per_in_ler_id = pen.per_in_ler_id
129: --Start Bug 2688172
130: and pil.lf_evt_ocrd_dt <= p_lf_evt_ocrd_dt

Line 511: from ben_prtt_enrt_rslt_f pen, ben_per_in_ler pil

507: cursor c_sspndd_rslt is
508: select pen.prtt_enrt_rslt_id,
509: pen.object_version_number,
510: pil.per_in_ler_id
511: from ben_prtt_enrt_rslt_f pen, ben_per_in_ler pil
512: where pil.person_id = p_person_id
513: and pil.per_in_ler_id = pen.per_in_ler_id
514: --Start Bug 2688172
515: and pil.lf_evt_ocrd_dt <= p_lf_evt_ocrd_dt

Line 690: select ben_per_in_ler_s.nextval

686: ,p_voidd_dt => l_voidd_dt
687: ,p_bckt_dt => l_bckt_dt
688: ,p_clsd_dt => l_clsd_dt);
689: --
690: select ben_per_in_ler_s.nextval
691: into l_per_in_ler_id
692: from sys.dual;
693: --
694: l_object_version_number := 1;

Line 696: insert into ben_per_in_ler

692: from sys.dual;
693: --
694: l_object_version_number := 1;
695: --
696: insert into ben_per_in_ler
697: (per_in_ler_id
698: ,per_in_ler_stat_cd
699: ,prvs_stat_cd
700: ,lf_evt_ocrd_dt

Line 882: (p_module_name => 'ben_per_in_ler'

878: --
879: when hr_api.cannot_find_prog_unit then
880: --
881: hr_api.cannot_find_prog_unit_error
882: (p_module_name => 'ben_per_in_ler'
883: ,p_hook_type => 'AI');
884: --
885: end;
886: --

Line 1080: l_object_version_number ben_per_in_ler.object_version_number%TYPE;

1076: --
1077: -- Declare cursors and local variables
1078: --
1079: l_proc varchar2(72) := g_package||'update_Person_Life_Event';
1080: l_object_version_number ben_per_in_ler.object_version_number%TYPE;
1081: --
1082: l_procd_dt date := hr_api.g_date;
1083: l_strtd_dt date := hr_api.g_date;
1084: l_voidd_dt date := hr_api.g_date;

Line 1388: l_object_version_number ben_per_in_ler.object_version_number%TYPE;

1384: --
1385: -- Declare cursors and local variables
1386: --
1387: l_proc varchar2(72) := g_package||'update_Person_Life_Event';
1388: l_object_version_number ben_per_in_ler.object_version_number%TYPE;
1389: --
1390: begin
1391: --
1392: hr_utility.set_location('Entering:'|| l_proc, 10);