DBA Data[Home] [Help]

APPS.BEN_ENROLLMENT_RATE_API dependencies on PER_ALL_PEOPLE_F

Line 19: l_person_name per_all_people_f.full_name%type;

15: ,p_person_name out nocopy varchar2
16: )is
17: --
18: l_proc varchar2(72) := g_package||'person_details';
19: l_person_name per_all_people_f.full_name%type;
20: --
21: cursor c_person is
22: select full_name
23: from per_all_people_f per

Line 23: from per_all_people_f per

19: l_person_name per_all_people_f.full_name%type;
20: --
21: cursor c_person is
22: select full_name
23: from per_all_people_f per
24: ,ben_per_in_ler pil
25: ,ben_elig_per_elctbl_chc epe
26: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
27: and epe.per_in_ler_id = pil.per_in_ler_id

Line 90: l_person_name per_all_people_f.full_name%type;

86: )is
87: --
88: l_proc varchar2(72) := g_package||'chk_perf_min_max';
89: l_api_updating boolean;
90: l_person_name per_all_people_f.full_name%type;
91: --
92: Begin
93: --
94: hr_utility.set_location('Entering:'||l_proc, 5);