DBA Data[Home] [Help]

APPS.PER_RO_ADDRESS dependencies on HR_LOOKUPS

Line 104: from hr_lookups

100: where puc1.user_column_name = 'COUNTY CODE'
101: and puc1.user_table_id = put.user_table_id
102: and pucif1.user_column_id = puc1.user_column_id
103: and pucif1.value = (select lookup_code
104: from hr_lookups
105: where lookup_type = 'RO_PER_COUNTIES'
106: and enabled_flag='Y'
107: and meaning = p_address_line1)
108: and pucif1.user_row_id = purf1.user_row_id