DBA Data[Home] [Help]

APPS.PAY_FR_OVERTIME dependencies on PAY_USER_COLUMNS

Line 209: , pay_user_columns c1

205: , ci2.VALUE factor_value
206: from pay_user_rows_f r
207: , pay_user_column_instances_f ci1
208: , pay_user_column_instances_f ci2
209: , pay_user_columns c1
210: , pay_user_columns c2
211: where r.user_table_id = p_band_table_id
212: and p_date BETWEEN r.effective_start_date and r.effective_end_date
213: and c1.user_table_id = p_band_table_id

Line 210: , pay_user_columns c2

206: from pay_user_rows_f r
207: , pay_user_column_instances_f ci1
208: , pay_user_column_instances_f ci2
209: , pay_user_columns c1
210: , pay_user_columns c2
211: where r.user_table_id = p_band_table_id
212: and p_date BETWEEN r.effective_start_date and r.effective_end_date
213: and c1.user_table_id = p_band_table_id
214: and c1.user_column_id = ci1.user_column_id