APPS.GHR_CPDF_CHECK SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 991

   SELECT  to_number(value) into basic_pay
   FROM    pay_user_columns                     udc,
           pay_user_rows_f                      udr,
           pay_user_tables                      udt,
           pay_user_column_instances_f          uci
   WHERE   udc.user_column_name = column_name
   AND     effective_date between
           uci.effective_start_date and
           uci.effective_end_date
   AND     effective_date between
           udr.effective_start_date and
           udr.effective_end_date
   AND     udr.row_low_range_or_name = row_name
   AND     udt.user_table_name = table_name
   AND     udr.user_table_id = udt.user_table_id
   AND     udc.user_table_id = udt.user_table_id
   AND     uci.user_row_id = udr.user_row_id
   AND     uci.user_column_id = udc.user_column_id;