Posted on 2010-11-30
I need the following query to altered
where trunc(sysdate) between EFFECTIVEDATEFROM and EFFECTIVEDATETO
Without disturbing the above I want check one more cndition
if EFFECTIVEDATEFROM is less than sysdate and if EFFECTIVEDATETO is null then it should appear in output of query.
if EFFECTIVEDATEFROM is greater than sysdate and if EFFECTIVEDATETO is null then it should NOT appear in output of query.
and I need to conver this stored procedure with input MEMBER_ID OR EMPLOYEE_ID OR CLUB_ID