DBA Data[Home] [Help]

APPS.PER_ZA_USER_HOOK_PKG dependencies on PER_PERSON_TYPES

Line 36: FROM per_person_types typ

32: --
33: CURSOR c_system_person_type
34: IS
35: SELECT typ.system_person_type
36: FROM per_person_types typ
37: WHERE typ.person_type_id = p_person_type_id;
38: -- Local Variables
39: --
40: l_proc varchar2(40) := g_package||'validate_race';

Line 41: l_system_person_type per_person_types.system_person_type%TYPE;

37: WHERE typ.person_type_id = p_person_type_id;
38: -- Local Variables
39: --
40: l_proc varchar2(40) := g_package||'validate_race';
41: l_system_person_type per_person_types.system_person_type%TYPE;
42: BEGIN
43:
44: -- The Race segment is mandatory for employees, applicants and
45: -- contingent workers

Line 356: FROM per_person_types typ

352: -- Cursors
353: CURSOR c_system_person_type
354: IS
355: SELECT typ.system_person_type
356: FROM per_person_types typ
357: WHERE typ.person_type_id = p_person_type_id;
358:
359: -- Bug#12585688
360:

Line 366: l_system_person_type per_person_types.system_person_type%TYPE; --Bug#12585688

362: --
363:
364: l_proc varchar2(40) := g_package||'validate_emp_num';
365:
366: l_system_person_type per_person_types.system_person_type%TYPE; --Bug#12585688
367:
368: --
369: begin
370: