DBA Data[Home] [Help]

APPS.PAY_FR_COURT_ORDERS dependencies on PAY_USER_COLUMNS

Line 471: ,pay_user_columns c

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
475: ,pay_user_columns c3

Line 473: ,pay_user_columns c2

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
477: ,pay_user_rows_f r

Line 475: ,pay_user_columns c3

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'
479: and tab.user_key_units = 'N'

Line 509: ,pay_user_columns c

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'
513: and c.user_table_id = tab.user_table_id