APPS.PAY_FR_COURT_ORDERS dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 470: from pay_user_column_instances_f cinst

466: cursor csr_get_band_values is
467: select fnd_number.canonical_to_number(cinst.value) rate,
468: fnd_number.canonical_to_number(cinst2.value) high_value,
469: fnd_number.canonical_to_number(cinst3.value) low_value
470: from pay_user_column_instances_f cinst
471: ,pay_user_columns c
472: ,pay_user_column_instances_f cinst2
473: ,pay_user_columns c2
474: ,pay_user_column_instances_f cinst3

Line 472: ,pay_user_column_instances_f cinst2

468: fnd_number.canonical_to_number(cinst2.value) high_value,
469: fnd_number.canonical_to_number(cinst3.value) low_value
470: from pay_user_column_instances_f cinst
471: ,pay_user_columns c
472: ,pay_user_column_instances_f cinst2
473: ,pay_user_columns c2
474: ,pay_user_column_instances_f cinst3
475: ,pay_user_columns c3
476: ,pay_user_tables tab

Line 474: ,pay_user_column_instances_f cinst3

470: from pay_user_column_instances_f cinst
471: ,pay_user_columns c
472: ,pay_user_column_instances_f cinst2
473: ,pay_user_columns c2
474: ,pay_user_column_instances_f cinst3
475: ,pay_user_columns c3
476: ,pay_user_tables tab
477: ,pay_user_rows_f r
478: where tab.user_table_name = 'FR_COURT_ORDER_BANDS'

Line 508: from pay_user_column_instances_f cinst

504: -- Table structures changed - select below is if everything is in one row.
505: select fnd_number.canonical_to_number(R.row_low_range_or_name) low_value
506: ,fnd_number.canonical_to_number(R.row_high_range) high_value
507: ,cinst.value rate
508: from pay_user_column_instances_f cinst
509: ,pay_user_columns c
510: ,pay_user_rows_f r
511: ,pay_user_tables tab
512: where tab.user_table_name = 'FR_COURT_ORDER_BANDS'