DBA Data[Home] [Help]

APPS.GHR_CPDF_CHECK8 dependencies on PAY_USER_TABLES

Line 21: , pay_user_tables d

17: b.value
18: FROM pay_user_rows_f a
19: , pay_user_column_instances_f b
20: , pay_user_columns c
21: , pay_user_tables d
22: WHERE TRUNC(p_effective_date) BETWEEN b.effective_start_date AND b.effective_end_date
23: AND TRUNC(p_effective_date) BETWEEN a.effective_start_date AND a.effective_end_date
24: AND a.row_low_range_or_name = p_pay_plan ||'-'|| p_grade_or_level
25: AND c.user_column_name = p_step_or_rate