DBA Data[Home] [Help]

APPS.PER_RO_ADDRESS dependencies on PAY_USER_TABLES

Line 85: from pay_user_column_instances_f pucif, pay_user_columns puc, pay_user_tables put, pay_user_rows_f purf

81: begin
82:
83: select 1 into l_locality_exists from dual where p_address_line2 in (
84: select pucif.VALUE
85: from pay_user_column_instances_f pucif, pay_user_columns puc, pay_user_tables put, pay_user_rows_f purf
86: where puc.user_column_name = 'LOCALITY'
87: and puc.user_table_id = put.user_table_id
88: and pucif.user_column_id = puc.user_column_id
89: and put.user_table_name = 'RO_LOCALITY_DETAILS'