Oracle User Table Query

Oracle User Table Standard Query

      SELECT MAX ('YES')

        INTO l_value

        FROM hr.pay_user_tables put,

             hr.pay_user_columns puc,

             hr.pay_user_rows_f purf,

             hr.pay_user_column_instances_f pucif

       WHERE     put.business_group_id = puc.business_group_id

             AND put.user_table_id = puc.user_table_id

             AND puc.business_group_id = purf.business_group_id

             AND puc.user_table_id = purf.user_table_id

             AND TRUNC (p_effective_date) BETWEEN purf.effective_start_date

                                              AND NVL (

                                                     purf.effective_end_date,

                                                     TRUNC (p_effective_date))

             AND purf.business_group_id = pucif.business_group_id

             AND puc.user_column_id = pucif.user_column_id

             AND purf.user_row_id = pucif.user_row_id

             AND TRUNC (p_effective_date) BETWEEN pucif.effective_start_date

                                              AND NVL (

                                                     pucif.effective_end_date,

                                                     TRUNC (p_effective_date))

             AND put.business_group_id = 81

             AND put.user_table_name = 'L_TABLE_NAME'

             -- 'LEAVE_RESPONSIBILITY'

             AND UPPER (pucif.VALUE) = UPPER (l_column_name);