APPS.PER_JP_EXTRA_PERSON_RULES dependencies on PER_PERSON_TYPES

Line 22: l_system_person_type per_person_types.system_person_type%type;

18: --
19: -- Declare cursors and local variables
20: --
21: l_proc varchar2(72) := g_package||'chk_kana_format';
22: l_system_person_type per_person_types.system_person_type%type;
23: --
24: procedure local_chk_kana_format(p_input in varchar2
25: ,p_system_person_type in varchar2) is
26: l_input varchar2(255);

Line 64: from per_person_types

60: -- Added check for system_person_type
61: --
62: select system_person_type
63: into l_system_person_type
64: from per_person_types
65: where person_type_id = p_person_type_id;
66: --
67: -- Validation in addition to Row Handlers
68: --