DBA Data[Home] [Help]

APPS.GHR_PAY_CAPS dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 314: pay_user_column_instances_f uci

310: SELECT udr.row_low_range_or_name,udr.row_high_range
311: FROM pay_user_columns udc,
312: pay_user_rows_f udr,
313: pay_user_tables udt,
314: pay_user_column_instances_f uci
315: WHERE udt.user_table_id = l_user_table_id
316: AND udr.user_table_id = udt.user_table_id
317: AND NVL(p_effective_date,TRUNC(SYSDATE)) BETWEEN udr.effective_start_date AND udr.effective_end_date
318: AND udc.user_table_id = udt.user_table_id