DBA Data[Home] [Help]

APPS.PAY_FR_OVERTIME dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 207: , pay_user_column_instances_f ci1

203: , decode(scheme.overtime_scheme_type,'F',ci1.VALUE,null) hours_value
204: , decode(scheme.overtime_scheme_type,'P',ci1.VALUE,null) working_hours_value
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

Line 208: , pay_user_column_instances_f ci2

204: , decode(scheme.overtime_scheme_type,'P',ci1.VALUE,null) working_hours_value
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