APPS.PAY_JP_FORMULA_FUNCTION_PKG dependencies on FND_NUMBER

Line 82: and fnd_number.canonical_to_number(p_row_value)

78: and l_effective_date
79: between pur.effective_start_date and pur.effective_end_date
80: and nvl(pur.business_group_id, p_business_group_id) = p_business_group_id
81: and nvl(pur.legislation_code, l_legislation_code) = l_legislation_code
82: and fnd_number.canonical_to_number(p_row_value)
83: between fnd_number.canonical_to_number(pur.row_low_range_or_name)
84: and fnd_number.canonical_to_number(pur.row_high_range)
85: and puc.user_table_id = put.user_table_id
86: and puc.user_column_name = p_column_name

Line 83: between fnd_number.canonical_to_number(pur.row_low_range_or_name)

79: between pur.effective_start_date and pur.effective_end_date
80: and nvl(pur.business_group_id, p_business_group_id) = p_business_group_id
81: and nvl(pur.legislation_code, l_legislation_code) = l_legislation_code
82: and fnd_number.canonical_to_number(p_row_value)
83: between fnd_number.canonical_to_number(pur.row_low_range_or_name)
84: and fnd_number.canonical_to_number(pur.row_high_range)
85: and puc.user_table_id = put.user_table_id
86: and puc.user_column_name = p_column_name
87: and nvl(puc.business_group_id, p_business_group_id) = p_business_group_id

Line 84: and fnd_number.canonical_to_number(pur.row_high_range)

80: and nvl(pur.business_group_id, p_business_group_id) = p_business_group_id
81: and nvl(pur.legislation_code, l_legislation_code) = l_legislation_code
82: and fnd_number.canonical_to_number(p_row_value)
83: between fnd_number.canonical_to_number(pur.row_low_range_or_name)
84: and fnd_number.canonical_to_number(pur.row_high_range)
85: and puc.user_table_id = put.user_table_id
86: and puc.user_column_name = p_column_name
87: and nvl(puc.business_group_id, p_business_group_id) = p_business_group_id
88: and nvl(puc.legislation_code, l_legislation_code) = l_legislation_code