WEBADI JAVA LOV failing with search parameter

Hi All,

I have created a dependant LOV in webadi using JAVA LOV API.

Please find below the details of the JAVA Class Files and Oracle  API, I have used.

SQL Class File

===============

package oracle.apps.aexpap.XlAdi.TargetRCLov.sql;

import java.sql.Connection;

import java.sql.SQLException;

import oracle.apps.bne.exception.BneException;

import oracle.apps.bne.framework.BneWebAppsContext;

import oracle.apps.bne.utilities.sql.BneBaseSQL;

public class XlAdiTargetRCSQL extends BneBaseSQL {

    public XlAdiTargetRCSQL(BneWebAppsContext paramBneWebAppsContext,

                                    String paramString) throws SQLException,

                                                               BneException {

        Connection connection = paramBneWebAppsContext.getJDBCConnection();

        StringBuffer stringBuffer = new StringBuffer();

        stringBuffer.append("SELECT ffvv.flex_value, ffvv.description FROM apps.fnd_flex_value_sets ffvs ,apps.fnd_flex_values_vl  ffvv WHERE flex_value_set_name = 'AEXP_COA_RESPONSIBILITY_CENTER' AND ffvs.flex_value_set_id = ffvv.flex_value_set_id AND enabled_flag = 'Y' AND SYSDATE BETWEEN NVL(start_date_active, SYSDATE) AND NVL(end_date_active, SYSDATE) AND ffvv.attribute27 = :1");