342: and R.user_table_id = TAB.user_table_id
343: and l_effective_date between R.effective_start_date
344: and R.effective_end_date
345: and R.legislation_code = g_leg_code
346: and fnd_number.canonical_to_number (p_row_value)
347: between fnd_number.canonical_to_number (R.row_low_range_or_name)
348: and fnd_number.canonical_to_number (R.row_high_range)
349: and TAB.user_key_units = 'N'
350: and CINST.user_row_id = R.user_row_id
343: and l_effective_date between R.effective_start_date
344: and R.effective_end_date
345: and R.legislation_code = g_leg_code
346: and fnd_number.canonical_to_number (p_row_value)
347: between fnd_number.canonical_to_number (R.row_low_range_or_name)
348: and fnd_number.canonical_to_number (R.row_high_range)
349: and TAB.user_key_units = 'N'
350: and CINST.user_row_id = R.user_row_id
351: and l_effective_date between CINST.effective_start_date
344: and R.effective_end_date
345: and R.legislation_code = g_leg_code
346: and fnd_number.canonical_to_number (p_row_value)
347: between fnd_number.canonical_to_number (R.row_low_range_or_name)
348: and fnd_number.canonical_to_number (R.row_high_range)
349: and TAB.user_key_units = 'N'
350: and CINST.user_row_id = R.user_row_id
351: and l_effective_date between CINST.effective_start_date
352: and CINST.effective_end_date
473: and R.user_table_id = TAB.user_table_id
474: and l_effective_date between R.effective_start_date
475: and R.effective_end_date
476: and R.business_group_id = p_business_group_id
477: and fnd_number.canonical_to_number (p_row_value)
478: between fnd_number.canonical_to_number (R.row_low_range_or_name)
479: and fnd_number.canonical_to_number (R.row_high_range)
480: and TAB.user_key_units = 'N'
481: and CINST.user_row_id = R.user_row_id
474: and l_effective_date between R.effective_start_date
475: and R.effective_end_date
476: and R.business_group_id = p_business_group_id
477: and fnd_number.canonical_to_number (p_row_value)
478: between fnd_number.canonical_to_number (R.row_low_range_or_name)
479: and fnd_number.canonical_to_number (R.row_high_range)
480: and TAB.user_key_units = 'N'
481: and CINST.user_row_id = R.user_row_id
482: and l_effective_date between CINST.effective_start_date
475: and R.effective_end_date
476: and R.business_group_id = p_business_group_id
477: and fnd_number.canonical_to_number (p_row_value)
478: between fnd_number.canonical_to_number (R.row_low_range_or_name)
479: and fnd_number.canonical_to_number (R.row_high_range)
480: and TAB.user_key_units = 'N'
481: and CINST.user_row_id = R.user_row_id
482: and l_effective_date between CINST.effective_start_date
483: and CINST.effective_end_date