APPS.HR_RO_PERSON_VALIDATE dependencies on HR_LOOKUPS

Line 14: IF (hr_api.not_exists_in_hr_lookups (p_effective_date, p_lookup_type, p_argument_value ) ) THEN

10: IS
11: --
12: BEGIN
13: --
14: IF (hr_api.not_exists_in_hr_lookups (p_effective_date, p_lookup_type, p_argument_value ) ) THEN
15: hr_utility.set_message (800, 'HR_7209_API_LOOK_INVALID');
16: hr_utility.set_message_token ('ARGUMENT', p_argument);
17: hr_utility.raise_error;
18: END IF;

Line 81: FROM hr_lookups

77: AND pucif1.user_column_id = puc1.user_column_id
78: AND pucif1.business_group_id = p_business_group_id
79: AND pucif1.value =
80: (SELECT lookup_code
81: FROM hr_lookups
82: WHERE lookup_type = 'RO_PER_COUNTIES'
83: AND enabled_flag ='Y'
84: AND meaning = p_county
85: )