APPS.HR_JPBP_API dependencies on PER_JP_SCHOOL_LOOKUPS

Line 24: select * from per_jp_school_lookups

20:
21: l_proc varchar2(72) := g_package||'chk_school_id_name_comb';
22: --
23: cursor c1 is
24: select * from per_jp_school_lookups
25: where school_id = p_school_id;
26: --
27: cursor c2 is
28: select * from per_jp_school_lookups

Line 28: select * from per_jp_school_lookups

24: select * from per_jp_school_lookups
25: where school_id = p_school_id;
26: --
27: cursor c2 is
28: select * from per_jp_school_lookups
29: where school_name = p_school_name
30: and nvl(major,hr_api.g_varchar2)= nvl(p_major,hr_api.g_varchar2);
31: --
32: jp_school_rec per_jp_school_lookups%rowtype;

Line 32: jp_school_rec per_jp_school_lookups%rowtype;

28: select * from per_jp_school_lookups
29: where school_name = p_school_name
30: and nvl(major,hr_api.g_varchar2)= nvl(p_major,hr_api.g_varchar2);
31: --
32: jp_school_rec per_jp_school_lookups%rowtype;
33:
34:
35: begin
36: hr_utility.set_location('Entering:'|| l_proc, 10);