DBA Data[Home] [Help]

APPS.HR_BE_EXTRA_PERSON_RULES dependencies on PER_PERSON_TYPES

Line 37: FROM per_person_types

33: ,p_correspondence_language IN VARCHAR2) IS
34: --
35: CURSOR c_system_person_type(p_person_type_id NUMBER) IS
36: SELECT system_person_type
37: FROM per_person_types
38: WHERE person_type_id = p_person_type_id;
39: --
40: l_system_person_type per_person_types.system_person_type%TYPE;
41: BEGIN

Line 40: l_system_person_type per_person_types.system_person_type%TYPE;

36: SELECT system_person_type
37: FROM per_person_types
38: WHERE person_type_id = p_person_type_id;
39: --
40: l_system_person_type per_person_types.system_person_type%TYPE;
41: BEGIN
42: -- Added the validation for the Bug No. 6469769 to check whether the Belgium Legislation is installed or not.
43: -- Only if it is installed,the validation is performed.
44: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'BE') THEN