APPS.HR_RO_LOCATION_VAL dependencies on HR_LOOKUPS

Line 14: from hr_lookups

10: ) IS
11:
12: cursor csr_county_valid is
13: select 'x'
14: from hr_lookups
15: where lookup_type = 'RO_PER_COUNTIES'
16: and meaning = p_address_line_1
17: and enabled_flag ='Y';
18:

Line 45: from hr_lookups

41: where puc1.user_column_name = 'COUNTY CODE'
42: and puc1.user_table_id = put.user_table_id
43: and pucif1.user_column_id = puc1.user_column_id
44: and pucif1.value = (select lookup_code
45: from hr_lookups
46: where lookup_type = 'RO_PER_COUNTIES'
47: and enabled_flag='Y'
48: and meaning = p_address_line_1)
49: and pucif1.user_row_id = purf1.user_row_id