82: and l_effective_date
83: between pur.effective_start_date and pur.effective_end_date
84: and nvl(pur.business_group_id, p_business_group_id) = p_business_group_id
85: and nvl(pur.legislation_code, l_legislation_code) = l_legislation_code
86: and fnd_number.canonical_to_number(p_row_value)
87: between fnd_number.canonical_to_number(pur.row_low_range_or_name)
88: and fnd_number.canonical_to_number(pur.row_high_range)
89: and puc.user_table_id = put.user_table_id
90: and puc.user_column_name = p_column_name
83: between pur.effective_start_date and pur.effective_end_date
84: and nvl(pur.business_group_id, p_business_group_id) = p_business_group_id
85: and nvl(pur.legislation_code, l_legislation_code) = l_legislation_code
86: and fnd_number.canonical_to_number(p_row_value)
87: between fnd_number.canonical_to_number(pur.row_low_range_or_name)
88: and fnd_number.canonical_to_number(pur.row_high_range)
89: and puc.user_table_id = put.user_table_id
90: and puc.user_column_name = p_column_name
91: and nvl(puc.business_group_id, p_business_group_id) = p_business_group_id
84: and nvl(pur.business_group_id, p_business_group_id) = p_business_group_id
85: and nvl(pur.legislation_code, l_legislation_code) = l_legislation_code
86: and fnd_number.canonical_to_number(p_row_value)
87: between fnd_number.canonical_to_number(pur.row_low_range_or_name)
88: and fnd_number.canonical_to_number(pur.row_high_range)
89: and puc.user_table_id = put.user_table_id
90: and puc.user_column_name = p_column_name
91: and nvl(puc.business_group_id, p_business_group_id) = p_business_group_id
92: and nvl(puc.legislation_code, l_legislation_code) = l_legislation_code